GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

GeekInterview.com  >  Interview Questions  >  Data Warehousing
Go To First  |  Previous Question  |  Next Question 
 Data Warehousing  |  Question 74 of 92    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  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape