propagate issue

[Anonymous]

Hi,

I created a job that reads data from a flat file and changed in the built in schema the date pattern for a column from 'dd-mmm-yyyy' into 'yyyymmdd'. After confirming that I want to propagate this change I was hoping that in the tmap and tDBOutput steps after for this column the date format would also be changed, which was not the case.

How does this exactly work? I included a screenshot of the job.

Thanks

[manodwhb]

You need to change in the source component and syn with tmap and output component.

[Anonymous]

Thanks for the reply, but how do I sync it with the tmap and output components? I'm still new to TOS.

[manodwhb]

After connecting to the tmap with output component you by default it will sync.

[Anonymous]

Yeh, I also saw now a sync button however I was hoping that this process would go automatically instead of me having to do this manually for every object that follows after.

[manodwhb]

@dev323 ,when you connected a component with another component ,most of the components will get the schema of previous of the component.

[Anonymous]

Yeh, the only issue is that in my job I already have existing components like the tmap that are already related to a source component like a database input for example. If I change let's say a product code from length 10 to 20, I can delete the connector between the source and tmap component and it will update the first link in the tmap component, but it will still not propagate those changes to all the components after the tmap unless I individually press the 'sync columns' button for each component separately.