Surrogate Key Disadvantages??
Page 1 of 1 • Share •
Surrogate Key Disadvantages??
can you tell me if there are any disadvantages of using a surrogate key in the enterprise data warehouse ?
sgudavalli- Posts: 14
Join date: 2010-06-10
Age: 27
Location: Pune, India
Re: Surrogate Key Disadvantages??
No. Can't think of any.

ngalemmo- Posts: 1729
Join date: 2009-05-15
Location: Los Angeles

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@clearpeaks.- Posts: 15
Join date: 2009-02-25
Location: Barcelona (Spain)
Similar topics» Advantages and Disadvantages of logo bmp and logo psd
» Surrogate Key Disadvantages??
» Type 2 Fact table - Durable surrogate key?
» Advantages Disadvantages of Star Vs. Snowflake in your DW Env. Has anyone switched from one to another & Why ?
» Surrogate Key causing incorrect results
» Surrogate Key Disadvantages??
» Type 2 Fact table - Durable surrogate key?
» Advantages Disadvantages of Star Vs. Snowflake in your DW Env. Has anyone switched from one to another & Why ?
» Surrogate Key causing incorrect results
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum