knobit.org

I1 (2 points)

edu:Question

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

Also as Turtle · JSON-LD · RDF/XML

dcterms:licensehttps://creativecommons.org/licenses/by/4.0/
rdfs:labelI1 (2 points) en
schema:hasPartdq-sbvr-rule-anomalies I1a: missing derivation input added
schema:hasPartdq-sbvr-rule-anomalies I1b: derived value no longer required as keyed input
schema:identifierI1
schema:position4
schema:textDerivations, 1 each: (a) BR-110's derived_from omits Agreed Term, which its formula uses, so the dependency graph is incomplete - Agreed Term added to derived_from (adding FT-105 to fact_types as well is expected but not required); (b) BR-111 makes the maturity amount a mandatory value keyed in by the branch application while BR-110 derives it and DR-107 says it is never keyed in - the anomaly is reported, BR-111 is retired, and maturity_amount becomes derived (generated column or view) under physical_changes; keeping the captured column only with a dq-check against the derivation, said so, is acceptable. en

Used by

has questionTerm deposit data rules on PostgreSQL and Delta Lake (SBVR rule knowledge)
schema:isPartOfdq-sbvr-rule-anomalies I1a: missing derivation input added
schema:isPartOfdq-sbvr-rule-anomalies I1b: derived value no longer required as keyed input