O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

Slowly changing dimensions occur in almost every application. Type 1 SCDs simply overwrite historical values. Type 2 SCDs preserve historical values, and you need to design the schema for SCDs to include a start and end date so the ETL process knows what time period each member is valid. Type 2 SCDs must be referenced using surrogate keys because the business key is no longer unique. If you have wide records, you can reduce storage costs by splitting the attributes into a single Type 1 SCD record and multiple Type 2 records so that the Type 1 attributes won’t be repeated unnecessarily. Integration Services has a Slowly Changing Dimension Wizard that makes it easy to create the essential data flow transforms need to implement ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required