topic extract data from an oracle and postgres database in Talend Studio

extract data from an oracle and postgres database

Anonymous — Thu, 14 Feb 2019 13:41:02 GMT

Hello everyone, I will need your help I am beginner on talend and I meet some difficulty I have two databases: oracle and postgres,

I made my connection to both databases and I get all the table records,

knowing that databases have the same tables only record them are different.

I make the comparison between my recordings of the two databases in relation to a column that we will call col_ID and I have to recover the recordings which ID_column is present only in a single database I tried to do it with Tmap and T join but I can not do it

I hope I'm clear

Thank you for helping me

Re: extract data from an oracle and postgres database

manodwhb — Mon, 18 Feb 2019 05:29:36 GMT

@didi ,if you want to get only the matched records you need to do inner join.check the below link .

https://community.talend.com/t5/Design-and-Development/Doing-an-inner-join-using-a-tMap-component/ta-p/21572

Re: extract data from an oracle and postgres database

Anonymous — Tue, 19 Feb 2019 09:08:17 GMT

Thank you very much, I managed to do what I wanted