Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011

    Duplicate record handling...


    I have a question regarding the duplicate records handling. We are in the process of creating master index table for which we get the data from 4 different systems. What we plan to do is to merge the data (clean the data, and de dupe the data) and load the master index table. But we would like to flow the merged master data to the down stream system (4 systems from where we got the data) and update the record with the master data record.. How do we handle this? Thanks in advance for your help.

    Last edited by nanchil; 11-17-11 at 12:51.

  2. #2
    Join Date
    Jun 2003
    You'll need to identify a unique natural key for the datasets, in order to records in the master table to records in you source tables.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts