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

Content with tag dimension Rss

   Items 1 to 3 of 3   
 

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,152 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

Key column of a dimension in SSAS

When defining the attribute, we always specify the surrogate key as the key column for any attribute. I was just thinking if we could make use of the natural key instead of the surrogate key. i.e., in case of a product attribute, the surrogate key say...  Read more...
By Akalya 2009/04/23 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 2,111 reads
   Items 1 to 3 of 3   
 
Tags
dwh (2)    
analysis services (ssas) (1)    
blogs (1)    
deadlock (1)    
exclusive table lock (1)    
indexed views (1)    
natural key (1)    
normalization (1)    
scd (1)    
surrogate key (1)    
tablockx (1)