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

[Anonymous]

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

[Anonymous]

Hi,

   It seems you have posted the same query multiple times. Manohar has already replied to your query in the other post.

   Could you please close this duplicate post?

  https://community.talend.com/t5/Design-and-Development/extract-data-from-an-oracle-and-postgres-data...

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂