Data Cleaning Exercises

Glossary

Referential integrity

Every reference points at a row that exists, such as a payment's account.

Check references explicitly. Rows with missing or unknown references are quarantined with distinct reasons, not dropped.

Related: Null key, Quarantine