topic Re: Auto refresh of guess schema in Talend Studio

Auto refresh of guess schema

_AnonymousUser — Fri, 05 Feb 2016 14:26:15 GMT

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?

Re: Auto refresh of guess schema

Anonymous — Fri, 05 Feb 2016 15:36:21 GMT

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?

Not so easy, and depends on overall job design. Please search for "dynamic schema" on the forum, the are lot of discussions (https://www.talendforge.org/forum/search.php?search_id=1683024686)

Re: Auto refresh of guess schema

Anonymous — Fri, 05 Feb 2016 15:41:02 GMT

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

Re: Auto refresh of guess schema

Anonymous — Fri, 05 Feb 2016 15:50:06 GMT

'Dynamic schema' feature is available is TOS Commercial version. Else, you have to set schema manually.
Arnaud