What is the difference between business key and surrogate key ?

Showing Answers 1 - 2 of 2 Answers

Ravi Teja N

  • Sep 16th, 2011

Business Key is nothing but a natural key.Surrogate key is a system generator just like sequence in oracle.Basically we come across this in slowly changing dimensions type-II category.

  Was this answer useful?  Yes

Sreedhar Lokaray

  • Nov 3rd, 2011

Business key is a primary key in the operational system.
Surrogate key is a system generated primary key. In Dimensions and Facts we use Surrogate keys as Primary keys.

Please refer my answer for the question "When do we need surrogate key in data warehouse implementation?" in the Data Warehousing Concepts category of GeekInterview.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions