slow changing dimensions

Handling Slow Changing Dimensions (SSIS2012)

This post will explain the following:

  • Slow changing dimensions (SCD0,SCD1,SCD2 and SCD3)
  • Inferred Members
  • How to configure a SCD component in a data flow using SSIS2012

Slow-Changing Dimensions are a special data warehouse modeling technique, that allow you to manage how your ETL process will resolve updates and inserts into a dimension, so that you can tell your packages what to do if an attribute value changes.