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

Content with tag DWH Rss

   Items 1 to 3 of 3   
 

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,040 reads

Insert new values in dimension avoiding deadlock

TSQL code deadlock-safe for inserting new value into dimension  Read more...
By Federico Iori 2012/02/03 | Source: SQLServerCentral.com | Category: dwh
Rating: |  Discuss |   Briefcase | 1,153 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 | 645 reads
   Items 1 to 3 of 3   
 
Tags
dimension (2)    
scd (2)    
deadlock (1)    
exclusive table lock (1)    
indexed views (1)    
natural key (1)    
normalization (1)    
slowly changing dimensions (1)    
surrogate key (1)    
tablockx (1)    
t-sql (1)    
without ssis (1)