Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tag Slowly Changing Dimensions Rss

   Items 1 to 7 of 7   

Managing Slowly Changing Dimension with MERGE Statement in SQL Server

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.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,470 reads

SCD Implementation with TSQL

ETL for a SCD using only TSQL, without hash functions  Read more...
By Federico Iori 2012/11/13 | Source: | Category: scd
Rating: |  Discuss |   Briefcase | 1,146 reads

Slowly changing dimensions using T-SQL MERGE

Of all the technical solutions to the problem of slowly changing dimensions, the T-SQL MERGE statement is one of the most elegant.   Read more...
By Adam Aspin 2011/06/20 | Source: | Category: merge
Rating: |  Discuss |   Briefcase | 16,113 reads

Slowly Changing Dimensions

By Prakriti Agrawal 2010/02/08 | Category: data warehousing
Rating: (not yet rated) |  Discuss |   Briefcase | 3,019 reads

Slowly Changing Dimension in SQL Server 2005 – Part 2

This article is Part 2 in the series which explores the options available in SQL Server 2005 for Slowly Changing Dimensions  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,529 reads

Populating Dimension Tables with the SCD Task

ETLing dimensions through SQL Server 2000 DTS, has more or less been quite a hassle, what with the lengthy ActiveX scripts and lookups that have to be performed. Enter SQL Server 2005 Integration Services: The Slowly Changing Dimension task has made it much simpler.  Read more...
Rating:  Rate this |   Briefcase | 1,623 reads
   Items 1 to 7 of 7   
data warehousing (2)    
integration services (ssis) (2)    
merge (2)    
dwh (1)    
scd (1)    
sql server 2005 (1)    
t-sql (1)    
without ssis (1)