DSXchange

Hi,
I have a field where i want to populate records like 1,2,3,4 etc. I tried using sequence generator but its not populating the records correctly. I have 100 records so the last value that should go into this field is 100 but its populating a value which is more than 100. The configuration file is of 2 nodes. I think the problem is because of this two node file. Can anybody help me in getting the correct value using the same config file.

Thanks

By "sequence generator" do u mean a row generetor? I am assuming it to be row genetator. The row genrator will start the count from initial value and then increment it by the value specified for each node. First check if the colomn you are generating is of integer type. You will have to set the stage property Execution mode to Sequential and also specify the intitial value and increment in Field Properties tab (both 1 in your case).

Look into surrogate key generator.

Make the partition/collecting to round robin, You should see the max sequence key generated equals to the no of input rows
-- JK

... only if the total number of rows is a whole multiple of the number of partitions.