Siebel Data Quality Administration Guide > Configuring and Using Data Matching >

Process of Searching for and Merging Duplicate Records

When you run a batch process, and depending on the number of duplicates in your system and when you implement the SDQ module, you might find there are potentially hundreds of rows in the Duplicate Resolution views (in the Administration - Data Quality screen). In these instances, it is recommended that you use the following two-step process for searching for and merging duplicate records.

To search for and merge duplicate records, perform the following tasks:

1. Searching for Duplicate Records

   You search for duplicate records by creating a query to find duplicate records and then reviewing the query results. For example, you might want to create a query that includes a subset of all duplicate records where the Name field starts with the letter A.

2. Merging Duplicate Records

   After the query results appear, you merge duplicate records using either the Merge button or the Merge Records option.