load tables from source to target

Highlighted
Six Stars

load tables from source to target

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)

Moderator

Re: load tables from source to target

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: load tables from source to target

what about scd2 for all tables
Moderator

Re: load tables from source to target

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: load tables from source to target

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

Re: load tables from source to target

Hello,

Here is online documentation about:TalendHelpCenter: SCD scenario.

Let us know if it is OK with you.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Seven Stars

Re: load tables from source to target

Hi,

 

How do i choose schema in tOracleInput and tOracleOutput,

The shemas are varying for different tables.

 

Thanks

 

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch