Page 1 of 1

Need logic to read sequentially

Posted: Wed Feb 22, 2012 11:13 am
by vishu19aug
Hi,

I have the following logic to compare data with previous row -

Stagevar1 = input.name
stagevar2 = (if stagevar1 = stagevar3 then 1 else 0)
stagevar3 = stagevar1

The problem is - It needs the file to be sorted on field name. I just want the parallel job to read the records sequentially without any sort and output the result.

Any help is really appreciated.

Thanks,
Vishal Gupta

Posted: Wed Feb 22, 2012 11:18 am
by DSguru2B
Single node perhaps

Posted: Wed Feb 22, 2012 11:22 am
by vishu19aug
DSguru... I am very new to Datastage.. Can you please give any example or pointers for Single node.

Posted: Wed Feb 22, 2012 12:08 pm
by vishu19aug
I changed the properties of the transformer to run it sequentially .. and it is working now ..