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:

  • Type 1, for which no history is kept,
  • Type 2, for which history is kept for certain columns based on all changes at any time in a source system for individual records and
  • Type 3, for which history is kept for a very limited set of columns based on changes at a certain point in time for a bulk set of records.