Expert SQL Server™ 2005 Integration Services

4.6. Summary

As demonstrated, when working through your list of dimension change and processing requirements, SSIS provides great out-of-the-box support to handle a majority of the cases and data volumes in your organization. The SCD Wizard can deal with Type 0 fixed, Type 1 changing, and Type 2 historical attributes, and even handle the unique update requirements that inferred members require. But even in situations where the complexity or volume go beyond what the SCD Wizard can handle out-of-the-box, you can tweak the SCD outputs or even use other data flow features and components to build a custom solution that does scale and can deal with your unique situations.

As a natural extension to dimension ETL, Chapter 5 focuses on the requirements around fact table ETL practices using SSIS. Then, Chapter 6 shifts to taking your processed, loaded data in your dimension and fact tables, and processing it into the supporting Analysis Services objects that your BI solution leverages for analytics.