Recognises a past event judged against present data

Mida see tähendab

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.

Kuidas seda hinnatakse

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

Tugineb

Recognises a reference to a versioned table by business key aloneK-624 · Oskus
Explains history strategies and validity-period conventionsK-658 · Teadmine

Vajalik

Puudub