Surrogate vs natural keys and smart columns

View previous topic View next topic Go down

Surrogate vs natural keys and smart columns

Post  kevmel93 on Fri Aug 06, 2010 6:40 pm

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

View user profile

Back to top Go down

Re: Surrogate vs natural keys and smart columns

Post  BoxesAndLines on Mon Aug 09, 2010 9:59 pm

One of many Ralph articles on the subject
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum