Recognises history kept without its constraints checked

Mida see tähendab

A table with validity periods or a current-row flag, on a platform where no key can express "no two versions of one key overlap" or "exactly one current row per key", and no DQ rule checks either. Point-in-time joins then return two rows or none.

Kuidas seda hinnatakse

Flags the deficient case and passes the acceptable one. Deficient: `dim_account` with `valid_from`/`valid_to`, unique on `(account_identifier, valid_from)` only; two overlapping versions load, and a payment on the overlap is counted twice Acceptable: Two set checks: no overlapping periods per `account_identifier`, exactly one `is_current = TRUE` per `account_identifier`; `dimension: consistency`, threshold 100 %

Tugineb

Recognises inconsistent validity periods in a versioned tableK-623 · Oskus
Explains history strategies and validity-period conventionsK-658 · Teadmine
Explains rule enforcement mechanisms and platform enforcementK-356 · Teadmine

Vajalik

Puudub