Is surrogate key needed on master dimension tables?

Go down

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

Post  remiby on 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 on 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