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

Content with tag Natural Key Rss

   Items 1 to 2 of 2   

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: | Category: dwh
Rating: |  Discuss |   Briefcase | 676 reads

SQL Server: Natural Key Versus Surrogate Key

When designing a database to support applications you need to consider how you are going to handle primary keys. This article explores natural and surrogate keys, and discusses the pros and cons of each, allowing you to determine what makes the best sense in your environment when you are designing your databases.   Read more...
By Additional Articles 2011/02/15 | Source: Database Journal | Category: database design
Rating: (not yet rated)  Rate this |   Briefcase | 4,901 reads
   Items 1 to 2 of 2   
database design (1)    
dimension (1)    
dwh (1)    
indexed views (1)    
scd (1)    
surrogate key (1)    
surrogate keys (1)