topic Re: Oracle Database Multiple Queries in Talend Studio

Oracle Database Multiple Queries

DrGenious — Mon, 04 May 2020 11:20:19 GMT

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.

Re: Oracle Database Multiple Queries

manodwhb — Mon, 04 May 2020 11:47:11 GMT

@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.

Re: Oracle Database Multiple Queries

DrGenious — Mon, 04 May 2020 11:54:05 GMT

@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?

Re: Oracle Database Multiple Queries

manodwhb — Mon, 04 May 2020 12:59:16 GMT

@DrGenious, you can use a single tmap also.

Re: Oracle Database Multiple Queries

DrGenious — Mon, 04 May 2020 13:13:40 GMT

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

Re: Oracle Database Multiple Queries

manodwhb — Mon, 04 May 2020 15:41:31 GMT

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