Term Kind Topic What it is
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.