Oracle Database Multiple Queries

[DrGenious]

Hello,

I want to do 4 select queries into a database but in 4 different tables. How can I achieve that? Also have I to use tOracleInput or tOracleRow? 

Thanks in advance. 

[manodwhb · Accepted solution]

@DrGenious , all 4 select queries will return the same order if the columns then you can use a single tDBInput by writing union operator between 4 select queries. if you have different data and columns data types different and have join column between four select queries take 4 tDbinput and use tMap to join those.

[DrGenious]

@manodwhb  thank you a lot.  So I have to separate them by 2, combine them with 2 tmaps and after combine these tmaps with other tmap?

[manodwhb]

@DrGenious, you can use a single tmap also.

[DrGenious]

How is this possible with 4 dbs? Can tmap take more than 2 inputs? 

[manodwhb]

Yes. You can connect more than 2 tdbinput in single tMap, and one would be main others are lookups.