Surrogate Key Disadvantages??

sgudavalli at 11h20
14
Jun
2010
Surrogate Key Disadvantages??

can you tell me if there are any disadvantages of using a surrogate key in the enterprise data warehouse ?

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
SET2/Q 1.Discuss the relative advantages and disadvantages
Q 1.Discuss the relative advantages and disadvantages of the different methods of distributing questionnaires to the respondents of a study. (10 marks).
Surrogate vs natural keys and smart columns
Some of my co-workers have proposed that we use natural keys in our slightly normalized data warehouse table structures. These table will be used to populate our fact and dimension tables. In example, one of our primary key structures would consist of a
What are the advantages and disadvantages of PHP?
What are the advantages and disadvantages of PHP? --------------------------------------- SEO Glasgow SEO Costs
Advantages Disadvantages of Star Vs. Snowflake in your DW Env. Has anyone switched from one to another & Why ?
Can anyone list the advantages and disadvantages of Star vs. Snowflake in your DW environement . And has anyone switched from one to another and why?
Surrogate Key causing incorrect results
Hi Sorry for the newbie question, i am just starting out with SSAS and I am trying to figure out how to do the following:- I have a applications fact table with a surrogate key (auto number) and business key, I am trying to calculate applications
Forums from same category
See also
more_less
Informations

2 Replies For the topic :
"Surrogate Key Disadvantages??"

This topic has been viewed 2135 times.

Last message :
14/06/2010 at 11h20 by "sgudavalli"