Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Surrogate Key Disadvantages??

3 posters

Go down

Surrogate Key Disadvantages?? Empty Surrogate Key Disadvantages??

Post  sgudavalli 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 : 39
Location : Pune, India

Back to top Go down

Surrogate Key Disadvantages?? Empty Re: Surrogate Key Disadvantages??

Post  ngalemmo Mon Jun 14, 2010 11:27 am

No. Can't think of any.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Surrogate Key Disadvantages?? Empty Surrogate Key Disadvantages??

Post  alex.caminals 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.
alex.caminals
alex.caminals

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

Back to top Go down

Surrogate Key Disadvantages?? Empty Re: Surrogate Key Disadvantages??

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum