Managing Slowly Changing Dimension with MERGE Statement in SQL Server

Posted on SQL Server Central See other posts from SQL Server Central
Published on Tue, 18 Jun 2013 06:00:00 UT Indexed on 2013/06/24 22:28 UTC
Read the original article Hit count: 319

Filed under:

Slowly Changing Dimension (SCD) Transformation is a quick and easy way to manage smaller slowly changing dimensions but it has several limitations and does not perform well when the number of rows or columns gets larger. Arshad Ali explores some of the alternatives you can use for managing larger slowly changing dimensions.

Deployment Manager How to automate your .NET and SQL Server deployments
Deploy .NET code and SQL Server databases in a single repeatable process with Red Gate Deployment Manager. Start deploying with a 28-day trial.

© SQL Server Central or respective owner