C3 (2 points)
https://knobit.org/id/task/dq-rules/C3
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/C3 |
| rdfs:label | C3 (2 points) en |
| schema:hasPart | dq-rules C3a: nulls left to chance |
| schema:hasPart | dq-rules C3b: history judged against current reference data |
| schema:identifier | C3 |
| schema:position | 3 |
| schema:text | 1 each: (a) DQ-008 was copied from a check constraint, so on a nullable column every row with no employment type evaluates to UNKNOWN and fails - the null case is decided explicitly, with a separate completeness check if null is not allowed; (b) DQ-009 judges a historic application's currency against today's reference table, so rows that were valid when recorded start failing - it reads the reference data as at the application date instead. en |
Used by
| has question | Loan application data quality rules on Snowflake (DQ rule anomaly skills) |
|---|---|
| schema:isPartOf | dq-rules C3a: nulls left to chance |
| schema:isPartOf | dq-rules C3b: history judged against current reference data |