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.