Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
Feel free to let us know if it is what you are looking for.
Best regards
Sabrina