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  >  Basics
Go To First  |  Previous Question  |  Next Question 
 Basics  |  Question 69 of 111    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  |   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