Is surrogate key needed on master dimension tables?
2 posters
Page 1 of 1
Is surrogate key needed on master dimension tables?
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?
In this case could I use the natural key only? What do you think?
Re: Is surrogate key needed on master dimension tables?
All dimensions should use surrogate primary keys.
Similar topics
» the master detail tables facts
» Combining master and history tables to fact
» Extracting Master/Detail data into Staging Tables
» Surrogate keys and Dimension-to-Dimension links
» Customer Dimension is always needed?
» Combining master and history tables to fact
» Extracting Master/Detail data into Staging Tables
» Surrogate keys and Dimension-to-Dimension links
» Customer Dimension is always needed?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum