C1 (3 points)
https://knobit.org/id/task/physical-model/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/physical-model/C1 |
| rdfs:label | C1 (3 points) en |
| schema:hasPart | physical-model C1: deliberate snapshot kept, not reported as a duplicate |
| schema:identifier | C1 |
| schema:position | 1 |
| schema:text | The deliberate denormalisation survives. income_at_assessment and credit_score_at_assessment on FCT_ASSESSMENT duplicate DIM_CUSTOMER.monthly_income on purpose: the logical model marks them as point-in-time snapshots and the business needs an assessment reproducible as it stood. They are kept, and recorded as snapshots with a derivation or a note. Replacing either with a join to the dimension, or reporting it as an unmanaged duplicate, scores 0. en |
Used by
| has question | Loan application physical model on Snowflake (physical design anomaly skills) |
|---|---|
| schema:isPartOf | physical-model C1: deliberate snapshot kept, not reported as a duplicate |