Answer Detail: RE: What is surrogate key ? where we use it expalin wi...

GeekInterview.com > Interview Questions > Data Warehousing > Basics

Print |

Question: What is surrogate key ? where we use it expalin with examples

Answer: don't know

March 03, 2006 01:02:01	#10
Giridhar	Member Since: Visitor Total Comments: N/A
RE: What is surrogate key ? where we use it expalin wi...
Surrogate Key is the solution for critical column problems. For example the customur purcshases different items in differnt locations,for this situation we have to maintain historical data. By using surrogate key we can introduce the row in the datawarehouse to maintain historical data.