Skilirium

7. etapp: Andmekvaliteedi reeglite tuletamine

Kompetentsi Andmete modelleerimine knobit · K-713 · Oskus

Recognises a check measuring the wrong population

Mida see tähendab

The rows a check measures are not the rows the rule governs. Too wide, and rows the rule does not apply to pass trivially and dilute the failures; too narrow, and governed rows are never examined. The population is also the threshold's denominator, so a wrong population is a wrong threshold.

Kuidas seda hinnatakse

Flags the deficient case and passes the acceptable one. Deficient: `BR-020: each loan account has a maturity date`; `DQ-018` over all of `account` with `expression: account_type_code <> 'LOAN' OR loan_maturity_date IS NOT NULL`. 60 % are current accounts and pass, so 25 % of loan accounts failing reports as 90 % Acceptable: `population: account_type_code = 'LOAN'`, `expression: loan_maturity_date IS NOT NULL`: the same failures now report as 75 %

Vajalik

  • Puudub