extract data from an oracle and postgres database

[Anonymous]

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

[manodwhb · Accepted solution]

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

[Anonymous]

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