I2 (2 points)
https://knobit.org/id/task/physical-model/I2
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/I2 |
| rdfs:label | I2 (2 points) en |
| schema:hasPart | physical-model I2a: surrogate key without natural-key uniqueness |
| schema:hasPart | physical-model I2b: versioned dimension referenced by business key |
| schema:identifier | I2 |
| schema:position | 5 |
| schema:text | 1 each: (a) DIM_CUSTOMER has a surrogate key and nothing makes customer_id unique, so a reloaded source silently doubles every customer; (b) FCT_ASSESSMENT references the versioned customer dimension by customer_id rather than by its surrogate key, so no point-in-time join is possible and the assessment resolves to whichever version is current. en |