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
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 :-)
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.
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
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 :-)
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema