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

[muralam]

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]

All those tables have same structure?

[Anonymous]

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 · Accepted solution]

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

[Anonymous]

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

Name:Age:Address

as,12,pp

ak,13,op

....

[Anonymous]

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]

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

Is any way to mention multiple delimiter?

[Anonymous]

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/2...?

Best regards

Sabrina