topic toracle tablelist or any database tablelist in Talend Studio

toracle tablelist or any database tablelist

Anonymous — Thu, 08 Nov 2018 13:10:01 GMT

can anyone share the scenarion about toracletablelist

i'm getting confused at tablename like "TNAME is '%%'" what is the meaning ?

i want load 10 tables into one table with same structure?

i want load 10 tables with different structure

Re: toracle tablelist or any database tablelist

Anonymous — Thu, 08 Nov 2018 13:53:39 GMT

Hi Ram,

If you give the drop down like below (please note that I am using USER_TABLES)

tDBableList component will run a query in Oracle as below.

SELECT TABLE_NAME FROM USER_TABLES WHERE TABLE_NAME LIKE '%EMPLOYEE%'

It means it will fetch all tables under that connected user having EMPLOYEE as part of table name (like employee, employees, employee100, 110employee etc).

Once you get the table name, you can use it in iterative manner in subsequent components (like tOracleInput).

Please note that since we need to provide schema beforehand for tOracleInput, you will have to make sure that schema details are same for all the tables selected using tDBTablelist component.

If the answer has resolved your query, could you please mark the topic as resolved? Kudos are also welcome 🙂

Warm Regards,

Nikhi Thampi

Re: toracle tablelist or any database tablelist

Anonymous — Wed, 08 May 2019 14:51:54 GMT

Dear Nikhi Thambi,

For me, Tablelist component is working fine and it is getting iterated correct number of times.

Can you please suggest how to capture the table name in DBInput from tablelist component during the iteration.

Thanks

Rajesh

Re: toracle tablelist or any database tablelist

Anonymous — Wed, 08 May 2019 18:17:54 GMT

@Rajeshapril17

Your use case might be different from @rchinta .

So could you please create a new post with following details so that we are not diluting the focus to current post? In your post, please provide the following details.

a) Your current job flow screenshots and description of what you are trying to achieve

b) Error screenshot if you are getting any error

c) Sample input data

d) Expected output data and data you are currently getting at output

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂