Talend Job different tables issue

MOussama1677058714 — Fri, 15 Nov 2024 22:04:33 GMT

Hello,

I'm new to talend and i'm working on a project where i need to create a job that takes a database connection , retrieve the list of tables in the database and then for each table i have to create a tmap to do some processing on columns , my problem here is that when i use TDBtablelist the iteration happens together while i need to get each table ( each iteration ) single handed and use it for tdbinput to then connect it to tmap.

What i'm getting now is all the tables together not each table on its own.

i'm sorry if this sounds confusing i'm new and i'm trying to learn about it.

If anyone knows what to do to solve my problem

thank you

Re: Talend Job different tables issue

Anonymous — Thu, 23 Feb 2023 04:34:57 GMT

Hello,

If we understand your requirement very well, you are able to list the name of the current tables in the source and then iterate and make a "select * from [global_variable]" with the dynamic schema.

The workflow would be:

tDBTableList-->tJava-->OnComponentOk-->tDBInput-->tMap-->OutPut

Here is a related topic:

https://community.talend.com/s/question/0D53p00007vCmNZCA0/whole-database-migration-mssqlmysql-using-dynamic-schema

Feel free to let us know if it is what you are looking for.

Best regards

Sabrina

topic Re: Talend Job different tables issue in Talend Studio

Talend Job different tables issue

Re: Talend Job different tables issue