Skip to Content
0
Former Member
Nov 12, 2009 at 07:16 PM

Context Node Comparision - Need Idea

29 Views

Hi Experts

I have a context node with some data, I do have another context node with different name and same attributes of 1st context node. The first context node holds data from UI, the second context node holds data from DB. I need to check these 2 and find out the new, changed and deleted records. I do have a unique identifier in both tables. I need to populate the new, changed and deleted in 3 different tables. New records or Changed records or Deleted records refers to Database.

New: If an entry from UI is new to Database

Changed: If an entry from UI and the same entry from Database has different attribute values.

Deleted: If an entry from Database is not found in UI. I mean the new set of Data in UI misses a few records from Database.

Please advice with your valuable thoughts

Thanks

Ramamoorthy D