Im trying to fill a primary key field of a target using a trigger on the table to insert a sequence number for each insertion of a new row.After running the session im finding that the key column is populated ,but,not in an order. the key field starts with some 75 goes till 200,the again 551 comes and goes till 10500 ,suddenly the next key field is filled with 21 and goes till 72.... is there any reason why this is happening in this reason.FYI : i truncated the table data ,then dropped the seq. and the trigger and created them freshly ,specifying the start value in seq. as "1"still the same problem :(

  • Interview Candidate
  • 4
  • 2453

Showing Answers 1 - 4 of 4 Answers

rajani

  • Oct 10th, 2006
 

Use sequence transformer to resolve this problem. In transformer properties you need to set start and end value and other properties...

  Was this answer useful?  Yes

ashis.mohapatra

  • Sep 16th, 2009
 

It depends what database you are using. If you are using Oracle or SQL server it should not be the case. But if your database is Teradata or Netezza then that will happen. Because Teradata and Netezza uses multiple parallel processing units.

Thanks
Ashis

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions