Answer Detail: RE: What is the data type of the surrogate key?

GeekInterview.com > Interview Questions > Data Warehousing

Print |

Question: What is the data type of the surrogate key?

December 12, 2007 07:47:17	#3
VAMSIKRISHNACH	Member Since: December 2007 Total Comments: 7
RE: What is the data type of the surrogate key?
1.It is always integer. 2.This is because we are generating a key and best performance comes only when keys are numeric. so they generate keys numerically only so that sorting is also quiet cheap for numbers compared to char,varchar..