Surrogate Key Disadvantages??

View previous topic View next topic Go down

Surrogate Key Disadvantages??

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

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 : 33
Location : Pune, India

View user profile

Back to top Go down

Re: Surrogate Key Disadvantages??

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

No. Can't think of any.
avatar
ngalemmo

Posts : 3000
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 on Wed Jun 23, 2010 7: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.
avatar
alex.caminals

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

View user profile

Back to top Go down

Re: Surrogate Key Disadvantages??

Post  Sponsored content


Sponsored content


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