C1 (4 points)
https://knobit.org/id/task/dq-rules/C1
Also as Turtle · JSON-LD · RDF/XML
| dcterms:license | https://creativecommons.org/licenses/by/4.0/ |
|---|---|
| owl:sameAs | https://bitbucket.org/reffa/ontology/id/task/dq-rules/C1 |
| rdfs:label | C1 (4 points) en |
| schema:hasPart | dq-rules C1a: dq-check rule cited by no check |
| schema:hasPart | dq-rules C1b: unenforced unique constraint unchecked |
| schema:hasPart | dq-rules C1c: derived column unchecked |
| schema:hasPart | dq-rules C1d and C1e: version overlap and one-current unchecked |
| schema:hasPart | dq-rules C1f: state-transition rule undetected |
| schema:hasPart | dq-rules C1g: check unable to fail |
| schema:hasPart | dq-rules C1h: check with no rule |
| schema:identifier | C1 |
| schema:position | 1 |
| schema:text | The coverage gaps, 0.5 each. These are absences: the thing to name is the rule or constraint with nothing behind it, not a check id. (a) BR-004 is enforcement dq-check and no check cites it; (b) UK_DIM_CUSTOMER_VERSION is not enforced by Snowflake and nothing checks it; (c) FCT_APPLICATION.total_collateral_value carries a derivation and no check compares it with the collateral fact; (d) nothing checks that a customer's validity periods do not overlap; (e) nothing checks that exactly one version per customer is current; (f) BR-009 is a state-transition rule assigned to the application, with nothing that would detect a breach - either history is asked for or the gap is recorded as accepted; (g) DQ-001 is completeness on a NOT NULL column, which Snowflake does enforce, so it can never fail and is removed or rescoped; (h) DQ-005 has no source rule and no source requirement. en |
Used by
| has question | Loan application data quality rules on Snowflake (DQ rule anomaly skills) |
|---|---|
| schema:isPartOf | dq-rules C1a: dq-check rule cited by no check |
| schema:isPartOf | dq-rules C1b: unenforced unique constraint unchecked |
| schema:isPartOf | dq-rules C1c: derived column unchecked |
| schema:isPartOf | dq-rules C1d and C1e: version overlap and one-current unchecked |
| schema:isPartOf | dq-rules C1f: state-transition rule undetected |
| schema:isPartOf | dq-rules C1g: check unable to fail |
| schema:isPartOf | dq-rules C1h: check with no rule |