dynamic load(insert) and update for multiple tables (Perform SCD 1)
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.
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.
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.
