Slowly changing dimensions

Slowly Changing Dimensions describe how to handle the attributes of a dimension that change rarely, such as a customer's address. Depending on the need, you overwrite the old value (type 1), keep the history by adding rows (type 2) or keep the old value in a dedicated column (type 3).

Example

Type 1: the address is overwritten. Type 2: a new row is added with its validity dates.

Related concepts

The whole glossary