toracle tablelist or any database tablelist

Highlighted
Six Stars

toracle tablelist or any database tablelist

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 

Highlighted
Employee

Re: toracle tablelist or any database tablelist

Hi Ram,

 

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

  

      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

Highlighted
One Star

Re: toracle tablelist or any database tablelist

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

Highlighted
Employee

Re: toracle tablelist or any database tablelist

@Rajeshapril17 

 

Your use case might be different from @ram2 .

 

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 :-)

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog