DSXchange

In 4 nodes the numbers are not generated in sequence. It leaves gaps in between.

I want to generate sequence numbers starting from 1 every time the job run. Number should be generated in sequence without gaps in 4 node job. Thing i have already tried 1) (@inrownum - 1) * @numpartitions + @partitionnum + 1 The above formula only works in 2 node. 2) Column generator - It creates g...