Click here to monitor SSC
SQLServerCentral is supported by Redgate
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 | 693 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 | 5,028 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)