Surrogate Key Disadvantages??

View previous topic View next topic Go down

Surrogate Key Disadvantages??

Post  sgudavalli on Mon Jun 14, 2010 2:20 am

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

View user profile

Back to top Go down

Re: Surrogate Key Disadvantages??

Post  ngalemmo on Mon Jun 14, 2010 8:27 am

No. Can't think of any.

ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Surrogate Key Disadvantages??

Post  alex.caminals@clearpeaks. on Wed Jun 23, 2010 4:07 am

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.

alex.caminals@clearpeaks.

Posts: 15
Join date: 2009-02-25
Location: Barcelona (Spain)

View user profile

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