I5 (2 points)
https://knobit.org/id/task/physical-model/I5
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/physical-model/I5 |
| rdfs:label | I5 (2 points) en |
| schema:hasPart | physical-model I5a: copied branch name |
| schema:hasPart | physical-model I5b: stored sum without derivation |
| schema:identifier | I5 |
| schema:position | 8 |
| schema:text | Copies and derivations, 1 each: (a) FCT_APPLICATION.branch_name is copied from DIM_BRANCH with nothing keeping it in step - either removed, or kept with a derivation naming what refreshes it and a check that notices drift; (b) DIM_APPLICATION.total_monthly_income is a stored sum with no derivation recorded. en |
Used by
| has question | Loan application physical model on Snowflake (physical design anomaly skills) |
|---|---|
| schema:isPartOf | physical-model I5a: copied branch name |
| schema:isPartOf | physical-model I5b: stored sum without derivation |