DSXchange

Hello ,
I have a requirement to convert the decimals values (generated as an output of aggregator ) to standarformat of xx.xx.

Example :

.32 -> 00.32
-1.5 -> -01.50
8 -> 00.80

I can do this in sql query , but as soon as the data gets processed by datastage aggregator , the decimal formatting just vanishes .

Any help appreciated .

Non-significant zeroes are not part of a "decimal" format. If you want to preserve / add those, you'll need to target a string and use a function like FMT().