Deduplicating or joining at the wrong grain deletes or multiplies real data. State the grain before choosing keys.
- Lesson: Find the row grain before removing duplicates
- Practise: Deduplicate order lines at the right grain
Related: Deduplication, Composite key