Analytics in Action

Managing Type 1 Slowly Changing Dimensions (SCD) Using T-SQL

When building dimensional models it is crucial to decide on how changes in source data will be represented in dimension tables. This phenomena is called slowly changing dimensions.

When it is not necessary to preserve the history, a Type 1 Slowly Changing Dimension can be used. This technique is commonly used in situations when the changed is implemented to correct an error.

This tutorial provides a practical , follow-along, demonstration of how to manage Type 1 Slowly changing dimensions using T-SQL

The sample code used in this tutorial can be downloaded here

admin