P29Data CleaningAdvancedInterpret18 min
Resolve Conflicting Customer Records
Create a defensible rule for conflicting customer records from CRM and billing systems.
#entity-resolution#source-priority#data-governance
Scenario
The same customer ID has different phone numbers and addresses in CRM and billing, each updated at different times.
Problem statement
Design a merge policy that preserves provenance and avoids overwriting trusted data blindly.
Your Task
- Define source priority by field, not by convenience.
- Use timestamps and validation rules.
- Keep a conflict log and original values.
Related Concepts
Master dataProvenanceEntity resolution
Ready to count this problem?
Mark it complete when you have reasoned through the solution in your own words.