Hi Guys,
I am trying to build a database which needs to be updated once in a month. I get same source every month(with additions and deletions from previous load) and i need to find newly added records and the missing records from the previous load(Delta). i need to check besed on a key field (SSN).
what is the most efficient way to calculate delta since i am working with appx 80 million records
any help would be appreciated
thanks in advance
I am trying to build a database which needs to be updated once in a month. I get same source every month(with additions and deletions from previous load) and i need to find newly added records and the missing records from the previous load(Delta). i need to check besed on a key field (SSN).
what is the most efficient way to calculate delta since i am working with appx 80 million records
any help would be appreciated
thanks in advance