Stage 7: Derive data quality rules
Knobit of Data modelling · K-715 · Skill
Recognises a past event judged against present data
What it means
A rule about a past event checked against today's state: today's reference data, `current_date`, the current version of a dimension. Rows that were valid when they were recorded start failing when the world moves on, and the failure count grows without a single bad row being loaded.
How it is assessed
Flags the deficient case and passes the acceptable one. Deficient: `account_currency_code` checked against today's `ref_currency`; after `EEK` was withdrawn in 2011 every account opened in kroon fails Acceptable: The check joins the ISO 4217 version valid on the account's opening date; `current_date` only in rules that are about now
Builds on
Needed by
- None