Row number issue

vij · Post by **vij** » Thu Jul 12, 2007 4:59 am

Hi all,

I am using Parallel Ex.I am facing a problem with @INROWNUM. Actually I have a job where I have to write a single record for any number of records from the source.

the job looks like this:

DataSet->Transformer->Sequential File

For any number of records from DataSet, I have to write a single record's values into that Sequential File.

So, I have used a @INROWNUM and it worked fine, when i have changed the 4 node configuration file, 4 records are written into that file. Now which System Varibale can be used, so that only one record is written into the file? Pls help me out.
Thanks in advance!
Vij

JoshGeorge · Post by **JoshGeorge** » Thu Jul 12, 2007 7:18 am

If you search in FAQ section you will find your answer.

sunil_acc · Post by **sunil_acc** » Thu Jul 12, 2007 7:47 am

@PARTITIONNUM + (@NUMPARTITIONS* @INROWNUM)

ray.wurlod · Post by **ray.wurlod** » Thu Jul 12, 2007 2:09 pm

You can not expect to write one row in parallel execution. @INROWNUM is calculated on each processing node. Constrain the job to execute in sequential mode - or in a single node node pool - irrespective of the number of nodes in the configuration file.

JoshGeorge · Post by **JoshGeorge** » Thu Jul 12, 2007 6:33 pm

This POST might be helpful.

DSXchange

Row number issue

Row number issue

try this