topic Re: Read multiple tables in sequence in Talend Studio

Read multiple tables in sequence

sunbaj — Sat, 01 Apr 2017 05:39:44 GMT

I have multiple tables in a database which have the same structure. I would like to read the tables in series and do some transfomation and then load them into the target. If I put a Union the issue is that unless all the records are fetched it does not start processing also duplicates in union will get deleted.
Also every week new set of tables are created. So I would like to design a process something like filelist where I can populate the list of tables and then iterate it one by one. How do I implement the same in Talend

Re: Read multiple tables in sequence

Anonymous — Wed, 05 Apr 2017 05:05:31 GMT

Hi,
Here is a component t<DB>TableList which read the table name from database one by one.
[font=Verdana, Helvetica, Arial, sans-serif]Best regards[/font]
[font=Verdana, Helvetica, Arial, sans-serif]Sabrina[/font]

Re: Read multiple tables in sequence

sunbaj — Thu, 06 Apr 2017 02:34:49 GMT

xdshi wrote:
Hi,
Here is a component t<DB>TableList which read the table name from database one by one.
[font=Verdana, Helvetica, Arial, sans-serif] Best regards[/font]
[font=Verdana, Helvetica, Arial, sans-serif] Sabrina[/font]

Thanks for helping. It did resolve my problem.

Re: Read multiple tables in sequence

Anonymous — Thu, 06 Apr 2017 03:15:09 GMT

Hi,
Could you please mark this topic as resolved?
Best regards
Sabrina