Skilirium

7. etapp: Andmekvaliteedi reeglite tuletamine

Kompetentsi Andmete modelleerimine knobit · K-725 · Oskus

Recognises an aggregate hiding a total failure

Mida see tähendab

A pass rate over the whole table that hides a part of it failing completely: one source system, one load, one region, one new product. 98 % overall can be 0 % for everything loaded since Tuesday.

Kuidas seda hinnatakse

Flags the deficient case and passes the acceptable one. Deficient: Completeness of `customer_segment_code` measured over twelve million rows; a new source sends none for a week, the rate falls from 99.1 % to 98.9 %, and nothing alerts Acceptable: Measured per load batch or per source (`population` or a grouping in the `set` query), or a second check scoped to the latest load

Vajalik

  • Puudub