How to get DATA from multiple tables at onece in ETL ???
Hi
I have 3 tables I need to get data out
lets call them pets, store, food (just an example)
I just want to get all the data from those tables, but with a join, mean that if pets have "petID" and so does store, than it will bring it and not show "petID" twice (you get my point, a usually join)
When I use the "tMysqlInput" I can choose more than one table (even 10 or more) at the Query design.
So there it works ok.
BUT
I need to choose table name for it, and there is more than one table.
Also,
I need to define "schema" for it, and need to id manually (not that good) and when I pass it to something like a "logger"
It doesn't work
Can someone please assist me here ?
Thank you.
Ok, so I will make 5 SQL input compents for reading the tables Right? And than to the TMAP But, on the tamp, I have one as the main, and the others as "lookup" tables And I want to get all the fiels, but with some kind of join Like if table 1 and 2 and 3 have ID, than it will make sure that each row is a join of those ID's How can it be done?
Hello Everone, I need a advise on this issue. I am building a data conversion job, where i need to look up using different built in queries from multiple tables(4)(using oracle input components - toracleInput) and validate that data on data in flat file, which i could do on the tmap component using relevant join operations, but my issue is the lookups run before the main flow from CSV componet starts, can any one help me on how i can make the lookups run for each iteration/row of the data from the main flow (flat file - tFileInputDelimited component) my thanks in advance Madhu
