Hello,
Here is the my situation: I have a table "products" of about 10,000 records in System 1. How I have to update this table intermittently, from a different System 2, which contains exactly same table and more correct data.
Approach 1: Delete all the records from table "products" in System 1 and load it from System 2 afresh.
Approach 2: Check against all the records existing in System2 for every record we have in System1; if exists update it or insert it.
Please advice.
Thanks