load tables from source to target

[Anonymous]

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)

[Anonymous]

Hello,

The dynamic schema feature will be available in talend subcription solution not open source.

The job looks like:
tOracleTableList--iterate--tOracleInput--main--tOracleOutput
on tOracleOutput, set a dynamic table name:
((String)globalMap.get("tOracleOutputTableList_1_CURRENT_TABLE"))
and select
'create table if not exist' option in the action on table list.

Best regards

Sabrina

[Anonymous]

what about scd2 for all tables

[Anonymous]

Hellom

Actually, I didn't get your job requirement about scd2 for all tables. Could you please us some background about your use case?

Best regards

Sabrina

[Anonymous]

actually after loaded into one table i need to implement scd2 for that table

[Anonymous]

Hello,

Here is online documentation about:TalendHelpCenter: SCD scenario.

Let us know if it is OK with you.

Best regards

Sabrina

[vidya821]

Hi,

How do i choose schema in tOracleInput and tOracleOutput,

The shemas are varying for different tables.

Thanks