Is surrogate key needed on master dimension tables?

Go down

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

View user profile http://www.horus-df.com/

Back to top Go down

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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Back to top

- Similar topics

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