DSXchange

Hello friends

Thanks for all ur valuable suggestion........its really helped me alot to go through my logic..........i just used this logic which is working fine now...

@PARTITIONNUM + ( @NUMPARTITIONS * (@INROWNUM - 1) ) + 1

even on 4 node..........

Thanks,
Rakesh.

Hi Kris.........ya i did that too..........in my job .......i have used the tail stage too see the max of surrogate key generated.......like if i am expecting max num to be 100.......but i am getting as 400.......which is a mutiple of 4.....
:roll:

What exactly do you want it to do when it runs on multiple nodes? Typically you want the 'round robin' effect that anbu mentioned, i.e. Node 1: 1,5,9,13 Node 2: 2,6,10,14 Node 3: 3,7,11,15 Node 4: 4,8,12,16 However, it seems like you want something else? :? Hi Chulett.......i need the data to read ...

Hi Anbu.........i tried with the logic as you have mentioned......but it is still incrementing by 4 while running on 4 node..........is there any other way possible............anyway thanks for the reply.

Hi Guys I want to generate sequential numbers in a parallel job with configuration file using 4 nodes. I have done the following in the transformer stage. 1) Created a stage variable for the counter named Skdelta. with the value as "@PARTITIONNUM - @NUMPARTITIONS + 1". 2) Set the derivatio...

hello freinds...i am rick ...i am new to the datastage...i have a question.. I am using mainframe, rs6000, db2 database,datastage version 7X and linux. my company has just moved all the server except mainframe to other places. now in most of the job which used to take 20 min to give result ...now ta...