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.
Business Intelligence is a very trendy term these days, managers want it, IT companies are selling it and users are loving the colors of the charts, the ability to drill and roll up between hierarchies drives them crazy, however most of them don´t know what Business Intelligence really is. They often refer to it as building a data warehouse where all company data is integrated with ETL tools like SQL Server Integration Services and analyzed with Analytical tools as SQL Server Analysis Services or even Excel. I am sorry guys, if you think BI is only about this, you are either using it or making it wrong. And start by thinking in this, although emails are a great technology, if you need to talk to a college seated right next to you, will you send him and email? What is the core of your problem here, the communication channel or the message being sent?