Bookshelf Home | Contents | Index | PDF |
Siebel Data Quality Administration Guide > Using Siebel Data Quality > Merging of Duplicate Records > Sequenced MergesYou use a sequenced merge to merge multiple records into one record. You assign sequence numbers to the records so that the record with the lowest sequence number becomes the surviving record, and the other records, the nonsurviving records, are merged with the surviving record. When records are merged using a sequence merge, the following rules apply:
Sequenced merge is especially useful if many fields are empty, such as when a contact record with a Sequence of 2 has a value for Email address, but its Work Phone number field is empty, and a contact record with a Sequence number of 3 has a value of Work Phone number. If the field Email address and Work Phone number in the surviving record (sequence number 1) are empty, the value of Email address is taken from the records with sequence number 2, and the value of Work Phone number is taken from the record of sequence number 3. A sequence number is required for each record even if there are only two records. |
Siebel Data Quality Administration Guide | Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |