DSXchange

ray.wurlod wrote:You do, however, have to tell the Aggregator stage that its inputs are sorted in addition to providing sorted input.

Thanks a lot Ray!
I am exploring different options.
How we can tell Aggregator stage that Inputs are already sorted.

Thanks!

Thanks Ray!
You are right. Input to Aggregator stage is not sorted.
However I am confused about how to sort the input data.
By UNIX sort or SyncSort or sort Stage.
Which method will provide best performance.

Hi, My Job design is: Seq File-Transformer-Aggregator-seq file. I am getting this error while running: Abnormal termination of stage TestZOCTRHS2_ChkDuplicates_Job1_v1..Aggregator_26 detected After reseting the job: getting following message: From previous run DataStage Job 89 Phantom 16362 jobnotif...

Thanks a lot Craig and DSGuru!

Both methods worked!
I will also use Stage Variables as it has to be done across multiple columns.

Take care!

chulett wrote:Treat the sign as a separate field and when it is "-" multiply the amount by -1.

Thanks Craig!
I am stuggling with how to code when part. Is there any function like:

if found "-" then ....else ...

or something on those lines?

Take care!

Hi All, Values for a source column in one of my job are as follows: 123.45- 985.24 234.67- 875.89 123.45- represents a negative number ( -123.45) I need to look for - at the end and if found convert this number to -123.45 so that I can perform mathematical calculations with this value. So my output ...

chulett wrote:I'm curious as to the 'why' of this... is the target of your 'desired output' a database table for instance? Flat file? Something else entirely?

Target is a flat file with which We need to perform mathematical calculations using datastage.

Thanks for all your help!

Hi ,

My input data is as follows:

Col A ( Number)
1,002.03
123,002.34
1,234,002.96

How do I remove comma (,) from numbers in datastage.
I know I can remove it using Unix but can it be done using Datastage?
My desired output is:


1002.03
123002.34
1234002.96

Thanks for all your help!