Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 

Content with tag SCD Rss

   Items 1 to 4 of 4   
 

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 | 873 reads

Enforcing surrogate key uniqueness in slowly changing dimension

Enforcing surrogate key uniqueness regards natural key in slowly changing dimension  Read more...
By Federico Iori 2012/01/03 | Source: SQLServerCentral.com | Category: dwh
Rating: |  Discuss |   Briefcase | 597 reads

Slowly Changing Facts

This article describes a design pattern for storing “effective dated" changes to fact tables.  Read more...
By Mark Murphy 2010/12/22 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 8,699 reads

Creating Inferred Dimension Members with SSIS

This article will show you how to use SSIS to create inferred dimension members on the fly during a fact table load process.  Read more...
By Robert Rubocki 2010/12/08 | Source: SQLServerCentral.com | Category: data warehouse
Rating: |  Discuss |   Briefcase | 6,717 reads
   Items 1 to 4 of 4   
 
Tags
dwh (2)    
data warehouse (1)    
dimension (1)    
etl (1)    
fact table (1)    
indexed views (1)    
integration services (ssis) (1)    
natural key (1)    
replication (1)    
script component (1)    
slowly changing dimension (1)    
slowly changing facts (1)    
star schema (1)    
surrogate key (1)    
t-sql (1)    
without ssis (1)    
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.