GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 69 of 113    Print  
what is the datatype of the surrgate key

  
Total Answers and Comments: 6 Last Update: January 11, 2008     Asked by: senthil 
  
 Sponsored Links

 
 Best Rated Answer
—

No best answer available. Please pick the good answer available or submit your answer.
July 25, 2006 13:44:15   #1  
ub        
RE: what is the datatype of the surrgate key
datatype of the surrgate key is either inteeger or numaric or number

 
Is this answer useful? Yes | No
August 23, 2006 14:39:24   #2  
Pavan Nadiger        
RE: what is the datatype of the surrgate key
Normally Surrogate keys are sequencers which keep on increasing with new records being injected into the table. The standard datatype is integer
 
Is this answer useful? Yes | No
September 12, 2006 02:11:56   #3  
Sahitya Bindu        
RE: what is the datatype of the surrgate key

Since Surrogate Keys are generated sequentially by the system the datatype should be of numeric type.


 
Is this answer useful? Yes | No
November 25, 2006 05:29:43   #4  
hari        
exactly

data type is: INT4 LENGTH: 10 DECIMAL PLACE: 0 (zero)


 
Is this answer useful? Yes | No
January 07, 2008 17:14:34   #5  
ankitmohansharma Member Since: December 2007   Contribution: 2    
RE: what is the datatype of the surrgate key
Hi all
Surrogate key is mostly a sequential number. Although it doesn't has to be.
They are system-generated artificial primary key values.
Typically every row would have both a primary key and a surrogate key. The primary key identifies the unique row in the database the surrogate key identifies the unique entity in the modelled world.
-Ankit
 
Is this answer useful? Yes | No
January 11, 2008 04:59:04   #6  
jaggu_mandya Member Since: January 2008   Contribution: 9    
RE: what is the datatype of the surrgate key

It is a system generated sequence number an artificial key used in maintaining history.
It comes while handling slowly changing dimensions


 
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