SQLServerCentral: Content tagged Slowly Changing Dimension

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Content with tag Slowly Changing Dimension

Items 1 to 3 of 3

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...

By Additional Articles 2013/06/18 | Source: Database Journal | Category: slowly changing dimension

Rating: (not yet rated) Rate this |

Briefcase | 1,681 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:

|

Briefcase | 896 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:

|

Briefcase | 13,431 reads

Items 1 to 3 of 3