GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing
Go To First  |  Previous Question  |  Next Question 
 Data Warehousing  |  Question 74 of 98    Print  
What is the data type of the surrogate key?

  
Total Answers and Comments: 5 Last Update: June 04, 2008     Asked by: pepsi 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
September 20, 2007 08:04:02   #1  
Suma        
RE: What is the data type of the surrogate key?
Always number
 
Is this answer useful? Yes | No
November 02, 2007 02:15:25   #2  
sindu        
RE: What is the data type of the surrogate key?
Numuric because it generates Numuric values.
 
Is this answer useful? Yes | No
December 06, 2007 07:47:17   #3  
VAMSIKRISHNACH Member Since: December 2007   Contribution: 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..
 
Is this answer useful? Yes | No
February 04, 2008 04:59:15   #4  
iksharan Member Since: February 2008   Contribution: 6    
RE: What is the data type of the surrogate key?
It Supposed to be Numeric Its Like Serial Numbers
 
Is this answer useful? Yes | No
June 04, 2008 01:06:26   #5  
tirukosri Member Since: October 2007   Contribution: 2    
RE: What is the data type of the surrogate key?
Surrogate keys are the system generated keys and used to eliminate the redundancy in the primary keys. So they are always integer numbers.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape