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  >  DataStage

 Print  |  
Question:  surrogate key

Answer: What is the Disadvantage of surrogate key stage?


July 07, 2008 15:01:21 #2
 rajul.ds   Member Since: July 2008    Total Comments: 3 

RE: surrogate key
 
to my concern if the data is not properly processed on nodes..in such suitations this surrogate key generates holes(simply skips the ordering )
ex:
aa-1
bb-2
ba..
bg...
cc-3
dd-4
ddd-5
here for ba and bg do not have seq key ,here ba and bg have holes
     

 

Back To Question