Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Surrogate vs natural keys and smart columns

2 posters

Go down

Surrogate vs natural keys and smart columns  Empty Surrogate vs natural keys and smart columns

Post  kevmel93 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

Back to top Go down

Surrogate vs natural keys and smart columns  Empty Re: Surrogate vs natural keys and smart columns

Post  BoxesAndLines Mon Aug 09, 2010 9:59 pm

One of many Ralph articles on the subject
BoxesAndLines
BoxesAndLines

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

Back to top Go down

Back to top

- Similar topics

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