topic Re: dynamic load(insert) and update for multiple tables (Perform SCD 1) in Talend Studio

dynamic load(insert) and update for multiple tables (Perform SCD 1)

kbuchade — Sat, 16 Nov 2024 03:49:52 GMT

Hi All,

I wanted to load multiple source files in to multiple tables through using single mapping in Talend dynamically. If it is insert then do insert or update then do update.

Scenario is: Perform SCD1 for multiple source files in multiple tables using single mapping dynamically.

I am using TOS.

Can anyone help me in this?

If you require more details on the scenario please let me know.

Re: dynamic load(insert) and update for multiple tables (Perform SCD 1)

Anonymous — Tue, 17 Dec 2019 07:49:12 GMT

Hello,

If you want to load a schema programatically into a job, you would connect the tSetDynamicSchema to the t<DB>Input component using an OnComponentOk. Once connected change the schema of the t<DB> Component to take dynamic type and tables name to use the global variable from t<DB>tableList.

tSetDynamicSchema is available in talend subscription solution not open source.

Best regards

Sabrina