topic loading tables from different DB and tables in Data Quality

loading tables from different DB and tables

Darmesh — Fri, 15 Nov 2024 23:35:12 GMT

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

Re: loading tables from different DB and tables

Anonymous — Thu, 28 Oct 2021 03:13:30 GMT

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

Re: loading tables from different DB and tables

Darmesh — Thu, 28 Oct 2021 09:52:44 GMT

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