Is surrogate key needed on master dimension tables?

View previous topic View next topic 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

View previous topic View next topic Back to top

- Similar topics

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