| |
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.
|
| May 05, 2008 06:39:11 |
#6 |
| madhava1238 |
Member Since: May 2008 Total Comments: 7 |
RE: Importance of Surrogate Key in Data warehousing?
|
surrogate key is nothing but a primary key,it gives a serial no. to all records.
surrogate key is act's as a major role in type 2 scenario.
if u have any updates to be applied on a database it will be directely effected on datawarehouse part(using surrogate key) |
| |
Back To Question | |
