Compare 2 tables and load only Updated and Inserted Rows

Description: Just a forum for any posts ;)
Moderators: Viki, Gus, datasource, Gemini, admins

spadekevin
spadekevin
Reputation: 0
With us: 29 days 16 hours

Post #1by spadekevin » Mon Jun 25, 2018 5:46 am

Hi,

Can someone please throw some light on how to compare a source table and destination table to check if there are any updates or inserts on source table and then perform update or insert operations on destination table? Please note that the source and destination tables has same schema and there is no Created Date and Updated Date but only has a Primary Key.

Any help will be apprecited.

I didn't find the right solution from the Internet.

References:
https://www.talendforge.org/forum/viewtopic.php?id=38991
Cryptocurrency App Video

Thank you.

Return to “Freestyle”