Answer Detail: RE: Importance of Surrogate Key in Data warehousing?&n...

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.

November 11, 2006 23:55:00	#4
vskanth	Member Since: Visitor Total Comments: N/A
RE: Importance of Surrogate Key in Data warehousing?&n...
surrogate is the systemgenerated key it is a numaric key it is primary key in the dimension table and it is forgien key in the fact table it is used to hadle the missing data and complex situation in the datastage

Back To Question