knobit.org

I1 (2 points)

edu:Question

https://knobit.org/id/task/dq-rule-derivation/I1

Also as Turtle · JSON-LD · RDF/XML

dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
rdfs:labelI1 (2 points) en
schema:hasPartdq-rule-derivation I1a: maturity-date check scoped to term deposits
schema:hasPartdq-rule-derivation I1b: agreed legacy tolerance with consistent severity and action
schema:hasPartdq-rule-derivation I1c: completeness reported per source and per migration tranche
schema:identifierI1
schema:position4
schema:textBR-204 and DEC-14: (a) 0.5 - the population is term deposits (product_family = 'TERM'), not every account; current and savings accounts have no maturity date; (b) 0.5 - the LP tolerance tells one story: threshold 98 % with DEC-14, Anu Lepp and 31 March 2027 in the comment, and an action that does not reject or quarantine the rows the agreement tolerates (warning with flag or report), while CORE stays at 100 %; (c) 1 - segmented: CORE and LP are measured separately (separate populations, or report_by source_system with a threshold per segment), so neither hides the other (0.5), and LP is reported per tranche (load_batch_id), so a tranche arriving with no maturity dates is not averaged into the 98 % (0.5). en

Used by

has questionDeposit mart data quality rules derived from the data rules and the Snowflake model (DQ rule derivation)
schema:isPartOfdq-rule-derivation I1a: maturity-date check scoped to term deposits
schema:isPartOfdq-rule-derivation I1b: agreed legacy tolerance with consistent severity and action
schema:isPartOfdq-rule-derivation I1c: completeness reported per source and per migration tranche