C4 (2 points)

https://knobit.org/id/task/dq-rules-profile/C4

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/task/dq-rules-profile/C4
rdfs:label	C4 (2 points) en
schema:hasPart	dq-rules-profile C4: data rule no valid data can satisfy
schema:identifier	C4
schema:position	4
schema:text	A data rule no valid data can satisfy, 1 each: (a) BR-109 (a basic payment account has no overdraft limit) cannot hold for any row that satisfies BR-104 (each current account has exactly one overdraft limit, enforced by ck_account_overdraft_limit), because BPA is in product family CURRENT - DQ-208's 0 % every night since go-live is the rule pair, not the data, and it is reported against the data rules naming both rules; (b) the resolution is in the data rules, not in the check: BR-104 gets its missing condition (current accounts other than basic payment accounts) or BR-109 is restated (the limit is zero), so the surviving rule is satisfiable - and DQ-208's threshold is not lowered to 0 % and the check is not retired as if the problem were solved. en

Used by

has question	Customer and payment data quality rules read against their profile and run results (DQ rule anomaly skills)
schema:isPartOf	dq-rules-profile C4: data rule no valid data can satisfy