toracle tablelist or any database tablelist

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 

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

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

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 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now