Slowly Changing Dimension

The slowly changing dimension approach defines how attributes such as customer address, job title, store class, or product category should be stored when they change over time. In some cases old values are overwritten, while in others historical records are preserved. This decision directly affects analytics, because it changes how historical reality is represented. Without SCD logic, historical reporting often becomes misleading.