Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 25 May 2004 @ 16:26:52 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Identity Columns
From:   Yankauskas, Barbara A


we had the same issue and had an incident opened with the GSC earlier this year. After research, the GSC noted that the identity feature was working as designed, from their e-mail to us:

  "After speaking w/ eng, this is working as designed. Note the following information from the developer -- the basis behind what you are seeing is that although completely sequential numbering is desired in the identity column, but Teradata has seperate starting points depending on the vproc (PE) that you connect to for your query..... Owing to Teradata's parallel architecture, the numbering scheme we are adopting will not generate numbers according to the arrival order of the data rows."  

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019