What is surrogate key ? how many surrogate key used in ur dimensions?

  • Interview Candidate
  • 3
  • 2539

Showing Answers 1 - 3 of 3 Answers

srinivas vadlakonda

  • Oct 12th, 2006
 

surrogate key is used to replacement of the primary key

DWH does not depends upon the primary key it is used to identify the internal records, each diemension should have atleast one surrogate key.

  Was this answer useful?  Yes

sn3508

  • Oct 25th, 2006
 

Surrogate key or warehouse key acts like a composite primary key.  If the target doesn't have a unique key, the surrogate key helps to address a particular row.  It is like a primary key in the target.

  Was this answer useful?  Yes

jayapraveen

  • Oct 14th, 2010
 

SURROGATE KEY IS NOTHING BUT WHAT A PRIMARY KEY IS USED IN AN TRANSACTION DATABASE ,GENERALLY THIS COME IN PICTURE WHEN THE DATA IS UPDATING REGULARLY IN THE TABLE THIS MAKES THE TABLE INCONSISTENT SO PRIMARY KEY CANNOT HANDLE THE TWO COLUMNS AT A TIME BECAUSE OF THIS SCENARIO SURROGATE KEY HAS COME IN PICTURE IT IS USED IN DATAWAREHOUSE ONLY
 IT IS MAINLY USED IN SCD-TYPE 2 BECAUSE IT SHOULD HANDLE THE PRESENT TABLE AND THE HISTORY TABLES,THE KEY WHICH IS MAINTAING HISTROY TABLE IS CALLED AS SURROGATE KEY

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