Surrogate vs natural keys and smart columns
2 posters
Page 1 of 1
Surrogate vs natural keys and smart columns
Some of my co-workers have proposed that we use natural keys in our slightly normalized data warehouse table structures. These table will be used to populate our fact and dimension tables. In example, one of our primary key structures would consist of a source system code (VARCHAR2(10)) and a policy key which is a smart column consisting of the policy number concatenated with the policy term effective date (VARCHAR2(50)). I am not sold on this approach. What are the cons of this approach? What are the cons of using natural keys? What are the cons of smart columns?
kevmel93- Posts : 2
Join date : 2010-08-06
Re: Surrogate vs natural keys and smart columns
One of many Ralph articles on the subject
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Hierarchy as Type 2 Change - Use Surrogate or Natural Key?
» Can a FACT table contains Natural Primary keys and text columns
» Business keys or Natural keys in the Fact table
» when source contains surrogate key instead of natural key
» SCD Type 1 and 2
» Can a FACT table contains Natural Primary keys and text columns
» Business keys or Natural keys in the Fact table
» when source contains surrogate key instead of natural key
» SCD Type 1 and 2
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|