Surrogate Key Disadvantages??
3 posters
Page 1 of 1
Surrogate Key Disadvantages??
can you tell me if there are any disadvantages of using a surrogate key in the enterprise data warehouse ?
sgudavalli- Posts : 29
Join date : 2010-06-10
Age : 39
Location : Pune, India
Surrogate Key Disadvantages??
There is obviously an overhead in the surrogate key pipeline (getting a new surrogate key for new dimensions records and getting them to the fact table instead of the natural keys from your data source).
However, this is a minimum cost compared to the benefits that surrogate keys will bring to the data warehouse.
However, this is a minimum cost compared to the benefits that surrogate keys will bring to the data warehouse.
alex.caminals- Posts : 15
Join date : 2009-02-25
Age : 48
Location : Barcelona (Spain)
Similar topics
» Fact table with non-numeric measure
» Should I use the surrogate key?
» Surrogate key for different granularities
» No Surrogate keys
» Surrogate key regeneration
» Should I use the surrogate key?
» Surrogate key for different granularities
» No Surrogate keys
» Surrogate key regeneration
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|