Term Kind Topic What it is
Attribute History Strategy concept Slowly Changing Dimensions The per-attribute decision about whether history is overwritten, versioned or kept alongside the current value, which is a business question rather than a technical one.
Fact Grain Multiplication Join Fan-Out, Dimension Row Explosion concept Slowly Changing Dimensions Silent duplication of fact rows when a fact is joined to a versioned dimension without an effective-date predicate, inflating every additive measure in proportion to how often dimension members change.
Slowly Changing Dimension SCD, Type 2 Dimension pattern Slowly Changing Dimensions A modelling technique for handling attributes that change over time, where the choice determines whether historical reporting stays correct.
Surrogate Key Binding As-Of Dimension Lookup, Version-at-Event Resolution pattern Slowly Changing Dimensions Resolving which version of a dimension row a fact belongs to at load time and storing that version's key on the fact - which is what freezes a historical report instead of letting it drift.