loading tables from different DB and tables

[Darmesh]

I have a scenario like

Database SAPC11 -- multiple tables -- only selected columns(not all columns)

Database SAPE03 -- multiple tables -- only selected columns(not all columns)

Database JDE -- multiple tables -- only selected columns(not all columns)

Database Lawson -- multiple tables -- only selected columns(not all columns)

i have around multiple tables from 13 DB. for example database SAPC11 has multiple table where i will do join and then load it to the target redshift. similarlly for all 13 database. how to do it

[Anonymous]

Hello,

What's talend product are you using?

Here is a dynamic schema which can be used in migrating data between databases one job. This feature is available in talend subscription solution not open source.

Best regards

Sabrina

[Darmesh]

i am using Talend data fabric. If we use dynamic schema, i am not going to take all the fields. only the required fields i need to take