Hi my requirement is i want to load tables from source to target there are different structure tables
after i need to implement scd2 on that total tables what is the procedure for that
actually i'm thinking with this (DYNAMIC schema + toracle tablelist + toracleoutput)
The dynamic schema feature will be available in talend subcription solution not open source.
The job looks like:
on tOracleOutput, set a dynamic table name:
'create table if not exist' option in the action on table list.
Actually, I didn't get your job requirement about scd2 for all tables. Could you please us some background about your use case?
Here is online documentation about:TalendHelpCenter: SCD scenario.
Let us know if it is OK with you.
Watch the recorded webinar!
Accelerate your data lake projects with an agile approach
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.