If a lookup table has two rows for one customer, every order for that customer appears twice and totals double. Check the lookup key is unique before joining, and compare row counts and totals before and after.
- Lesson: Quarantine with reasons, in rule order
- Practise: Referential integrity with explicit exceptions
Related: Referential integrity, Cardinality, Row grain