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.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.