| |
GeekInterview.com > Interview Questions > Data Warehousing > DataStage
| Print | |
Question: Importance of Surrogate Key in Data warehousing?
Answer: Surrogate Key is a Primary Key for a Dimension table. Most importance of using it is it is independent of underlying database. i.e Surrogate Key is not affected by the changes going on with a database.
|
| April 04, 2009 05:55:31 |
#7 |
| ASHOK1324 |
Member Since: April 2009 Total Comments: 36 |
RE: Importance of Surrogate Key in Data warehousing?
|
Primary Key does not allow data duplications for actual source data. We cannot maintain historical data of each record using PK.
SID acts as a primary key in target WH systems, that allows data duplications and maintains complete historical data along with current data. |
| |
Back To Question | |
