topic Re: Read data from mutiple tables with different schema and load it targte tables in Talend Studio

Read data from mutiple tables with different schema and load it targte tables

muralam — Tue, 06 Feb 2018 06:36:33 GMT

Hi,

please help me out i wanted to to implement a job in such a way,

i have to read tables with different schema from AccessDB and load it to oracle in a single job instead of creating multiple job or subjobs

eg: src a,b,c,d,.... to target x,y,z,

Thanks in Advance

Regards,

Meena

manodwhb — Tue, 06 Feb 2018 06:46:35 GMT

All those tables have same structure?

Anonymous — Fri, 23 Feb 2018 11:19:18 GMT

I have the same issue... In the database, I have 100 tables and all tables have different structure.

Is anyone know how we read table without knowing the schema

Anonymous — Fri, 23 Feb 2018 11:48:02 GMT

if you are using enterprise edition u can find option as dynamic schema .By using it u can complete your job

Anonymous — Tue, 27 Feb 2018 08:14:58 GMT

In some files, I have different delimiter in the header.

Name:Age:Address

as,12,pp

ak,13,op

....

Anonymous — Fri, 02 Mar 2018 07:25:38 GMT

Hello,

@spandit wrote:

In some files, I have different delimiter in the header.

Name:Age:Address

as,12,pp

ak,13,op

....

Does the "dynamic schema" feature work for you?

Best regards

Sabrina

Anonymous — Wed, 28 Mar 2018 14:12:21 GMT

No, In the dynamic option we have to select only one single delimiter.

Is any way to mention multiple delimiter?

Anonymous — Fri, 30 Mar 2018 09:14:24 GMT

Hello,

Your input source and target output are both tables? Have you already checked this online document about:https://community.talend.com/t5/Design-and-Development/How-to-process-changing-data-structure/ta-p/21702?

Best regards

Sabrina