Answer Detail: RE: Surrogate key

GeekInterview.com > Interview Questions > Data Warehousing > ETL

Print |

Question: Surrogate key

Answer: why we implement sarrogate key in ETL Process?

July 07, 2008 22:49:39	#3
vivek1708	Member Since: May 2008 Total Comments: 18
RE: Surrogate key
Using the primary key in the DW doesnt actually end up serving as the unique constraint, as the data inside a Warehouse, represents - a snapshot of a time and hence using the same primary key as used in the Operational warehouse, tends to violate this constraint. Hence we also use the Surrogate key also called the Datawarehousing key with moving data from ODS to DW, in order the contraints and logical integrity is met.