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.
If you don't use the Guess Query button you don't have to specify the right table name. To create the schema you can try to use the guess schema button the if it doesn't work you can create it manually cheers
amm I have tried, but getting problems Seem like the data isn't right and why can't I just AUTO create the schema? just like when selecting one table and let it guess the sql for it ?? Thank you!!
hi,
i'm not sure to correctly understand,
just put all your tables you need and connect them by a TMAP. One tmysqlinput by table.
You can use db connection in metadata an retrieve the schema for you tables.
After you can drag your table in your job, qry and schema are auto define.
Can you explain more about it please?
I have my tables, and defined the scehma for them (auto one)
Than, how can I use them all? means, I don't want just to get the data, but do some kind of join
Here is a example
If I have 3 tables
cars, date, people
people has both the car key and the date key
so I want to get all the cars to a someone on the date
Something like a join, but with more than two tables.
Just getting all the data, but having it on each row with the needed data that is sutible for the keys
I have read it!
Still don't understand
Lets say I want to get data out of 5 different tables
But, I don't just want to "take" all the data, but do somekind of JOIN, means that if table A and B has a common key like ID, it will use it.
How can this be done please?
