Aggregator O/p Data on summation
Posted: Wed Oct 13, 2004 10:00 pm
Hi,
In the aggregator stage, is there an option that the o/p of summation of a decimal field is produced in the desired decimal format - without any leading / trailing zeroes.
From example -(i/p and o/p from aggregator based on a key)
I/P --fld1 values--100,200, 300
O/P--Sum(fld)1---600.0 [and NOT 000006000.00 for dataype decimal(11,2) ]
I understand it can be handled later in downstream using a transformer stage. I am looking for a direct solution - possibly in the aggregator stage itself.
Thanks,
Nitin
In the aggregator stage, is there an option that the o/p of summation of a decimal field is produced in the desired decimal format - without any leading / trailing zeroes.
From example -(i/p and o/p from aggregator based on a key)
I/P --fld1 values--100,200, 300
O/P--Sum(fld)1---600.0 [and NOT 000006000.00 for dataype decimal(11,2) ]
I understand it can be handled later in downstream using a transformer stage. I am looking for a direct solution - possibly in the aggregator stage itself.
Thanks,
Nitin