Dimensions and SCD

A dimension describes the context of the facts (who, what, where, when) and is used to filter and group. SCDs (Slowly Changing Dimensions) handle the slow evolution of its attributes: type 1 overwrites the old value, type 2 adds a row with validity dates to preserve history.

Example

Customer moves: SCD type 2 = new row with date_debut and date_fin.

Related concepts

The whole glossary