Bi-kipedia
Slowly changing dimension
Slowly changing dimensions are a set of data warehouse techniques to deal with history within a dimension.Dimensions are related to facts and while the facts are basically always transaction oriented with an associated date, a dimension is not. Therefore a dimension may require history as well.3 basic types exist: