Is there any possibility to make guess schema in retrieve schema automatically refresh for every run of the job. If the new fields are added in database , then every time we need to open the job and has to click guess schema. In order to avoid this is there any other possibility?
Is there any possibility to make guess schema in retrieve schema automatically refresh for every run of the job. If the new fields are added in database , then every time we need to open the job and has to click guess schema. In order to avoid this is there any other possibility?
Hi,
In your job, when you create a query, the result go to the next composant with a row. In this row, you have your schema.
This schema can't use all table fields so it's difficult to have an option like this.
Today, you must open your project, modify your schema through your metadata and apply to your jobs.
Arnaud
