DSXchange

My table have sequnce no and while loading I need to increment this sequnce no for every record. Here I have to do truncate load so in OE stage, when I select Load option then i am not able to give sequnce.nextval for sequnce increment. Please help me ........

use a surrogate key generator stage and call your dbsequence from there to generate the surrogate key.