Five Stars

Data load using Dynamic schema (Dynamic data type in Enterprise version)

I want create a generic talend job with will load data from redshift to oracle table I have around 10-15 table for now .
For example:
Table1(Redshift) -> Generic_Talend_Job -> Oracle Table 1
Table2(Redshift) -> Generic_Talend_Job -> Oracle Table 2
the metadata for each source and target are different.i.e oracle and redshift table structures are same . But table 1 structure and table 2 structure are different .
I have seen option of dynamic data type in some blogs , but not sure how to incorporate the same for my case .
Sample job screenshot and configuration will be really helpful .

1 REPLY
Moderator

Re: Data load using Dynamic schema (Dynamic data type in Enterprise version)

Hello,

Please take a look at this troubleshooting-development topic: https://community.talend.com/t5/Troubleshooting-Development/How-to-process-changing-data-structure/t...

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.