🧹 3. Data Cleansing & Deduplication
Sub-topic 3 of 8
38% Complete
Duplicates degrade data quality. Siebel provides tools to identify and merge duplicate records.
Identifying Duplicates
Duplicate Detection Strategies
- Exact Match: Same Name + Email + Phone
- Fuzzy Match: Similar names (soundex, edit distance)
- Rule-Based: Business logic (same company + similar name)
Merge Process
- Identify duplicate records
- Select master record (most complete/recent)
- Merge related records (activities, opportunities)
- Deactivate or delete duplicate
