O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

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

Slowly Changing Dimensions (SCDs) in SSIS

Slowly Changing Dimensions (SCDs) is a term coined by Ralph Kimball refer to dimension tables that have data that slowly changes with time. These changes in data need to be recorded in order to make dimension table data refreshed and also to enable end user to analyse historical changes in data. For example, it could be necessary to let the Data Warehouse "know" when a customer's address changes (to make it possible to analyze sales by customer locations and have more focused marketing activities), or it could be necessary to update a product's name.

You could use several techniques to deal with these types of dimensions. One technique is explained in this recipe through an SSIS component created exclusively ...

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