Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,212 reads

SCD Implementation with TSQL

ETL for a SCD using only TSQL, without hash functions  Read more...
By Federico Iori 2012/11/13 | Source: SQLServerCentral.com | Category: scd
Rating: |  Discuss |   Briefcase | 1,070 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: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 15,233 reads

Slowly Changing Dimensions

By Prakriti Agrawal 2010/02/08 | Category: data warehousing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,988 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,468 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,533 reads
   Items 1 to 7 of 7   
 
Tags
data warehousing (2)    
integration services (ssis) (2)    
merge (2)    
dwh (1)    
scd (1)    
sql server 2005 (1)    
t-sql (1)    
without ssis (1)