You are not logged in.

Unanswered posts



Important! This site has been replaced. All content here is read-only. Please visit our brand-new community at https://community.talend.com/. We look forward to hearing from you there!



#1 2017-04-01 05:39:44

sunbaj
Member
40 posts

sunbaj said:

Read multiple tables in sequence

Tags: [oracle]

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

Offline

#2 2017-04-05 05:05:31

xdshi
Talend Team


xdshi said:

Re: Read multiple tables in sequence

Hi,
Here is a component t<DB>TableList which read the table name from database one by one.
Best regards
Sabrina


What we can do is to make sure that Talend will be your best choice!

Offline

#3 2017-04-06 02:34:49

sunbaj
Member
40 posts

sunbaj said:

Re: Read multiple tables in sequence

  xdshi wrote:

Hi,
Here is a component t<DB>TableList which read the table name from database one by one.
Best regards
Sabrina

Thanks for helping. It did resolve my problem.

Offline

#4 2017-04-06 03:15:09

xdshi
Talend Team


xdshi said:

Re: Read multiple tables in sequence

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


What we can do is to make sure that Talend will be your best choice!

Offline

Board footer

Talend Contributor Agreement - Talend Website Privacy Policy