C3 (2 points)

https://knobit.org/id/task/physical-model/C3

dcterms:license	https://creativecommons.org/licenses/by/4.0/
owl:sameAs	https://bitbucket.org/reffa/ontology/id/task/physical-model/C3
rdfs:label	C3 (2 points) en
schema:hasPart	physical-model C3: mixed grain found and resolved
schema:identifier	C3
schema:position	3
schema:text	The mixed grain is found and resolved: FCT_APPLICATION declares one row per application and is keyed on application and collateral together, so every measure on it repeats once per item of collateral and requested_amount double counts. Resolved by moving collateral to its own fact or bridge, or by restating the grain and removing the application-level measures - and the resolution says which measures were wrong. en

Used by

has question	Loan application physical model on Snowflake (physical design anomaly skills)
schema:isPartOf	physical-model C3: mixed grain found and resolved