DSXchange

Yes i did but with very small data. However, my job will process around 1 million records.

hi,

In my parallel job one stage (transformer) is sequential. Does it have any negative impact on performance? will it be bottleneck for the complete prallel flow?

Thanks,
Vishal

I changed the properties of the transformer to run it sequentially .. and it is working now ..

DSguru... I am very new to Datastage.. Can you please give any example or pointers for Single node.

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 an...

Thanks! it solved my problem

Hi, My data is something like name value a_00 123 a_00 134 a_01 123 a_01 143 a_00 125 a_00 134 a_02 213 a_02 123 I want the data to be transformed to - name value occurance a_00 123 1 a_00 134 1 a_01 123 1 a_01 143 1 a_00 125 2 a_00 134 2 a_02 213 1 a_02 123 1 Can somebody help, which stage to use? ...

Thanks! I can see only Pivot and Pivot Enterprise in version 8.7

Hi, I have the following input - Table_name attribute value table_000 field1 1200 table_000 field2 1300 table_000 field3 as table_001 field1 0 table_001 field2 1100 table_001 field3 ad I want the data in the follwong format - table_000 field1 1200 field2 1300 field3 as table_001 field1 0 field2 1100...