topic Re: load tables from source to target in Talend Studio

load tables from source to target

Anonymous — Wed, 21 Nov 2018 06:06:26 GMT

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)

Re: load tables from source to target

Anonymous — Tue, 27 Nov 2018 08:23:25 GMT

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

Re: load tables from source to target

Anonymous — Thu, 29 Nov 2018 04:22:35 GMT

what about scd2 for all tables

Re: load tables from source to target

Anonymous — Thu, 29 Nov 2018 07:29:44 GMT

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

Re: load tables from source to target

Anonymous — Thu, 29 Nov 2018 16:54:43 GMT

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

Re: load tables from source to target

Anonymous — Wed, 19 Dec 2018 08:04:31 GMT

Hello,

Here is online documentation about:TalendHelpCenter: SCD scenario.

Let us know if it is OK with you.

Best regards

Sabrina

Re: load tables from source to target

vidya821 — Fri, 12 Apr 2019 08:32:14 GMT

Hi,

How do i choose schema in tOracleInput and tOracleOutput,

The shemas are varying for different tables.

Thanks