Data engineering and IT

Slowly changing dimension

A way of handling attributes that change over time, such as a customer moving region.

  • Data engineering and IT

Definition

A way of handling attributes that change over time, such as a customer moving region. Type 1 overwrites; type 2 keeps history with valid-from and valid-to dates.

For your role

Choose your role to see what this term means in your work.

Why it matters

Where it is used

Warehouse design, and any report that asks what was true at the time.