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

Is surrogate key needed on master dimension tables?

2 posters

Go down

Is surrogate key needed on master dimension tables? Empty Is surrogate key needed on master dimension tables?

Post  remiby Fri Jul 19, 2013 12:10 pm

I am wondering whether it is really necessary to add a surrogate key for master tables (used as dimensions) like  dim_transaction_types or dim_currency. Such tables obviously does not have any SCD2 attributes.
In this case could I use the natural key only? What do you think?

remiby

Posts : 19
Join date : 2012-04-10
Location : Paris, France

http://www.horus-df.com/

Back to top Go down

Is surrogate key needed on master dimension tables? Empty Re: Is surrogate key needed on master dimension tables?

Post  ngalemmo Fri Jul 19, 2013 12:54 pm

All dimensions should use surrogate primary keys.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top


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