Page 1 of 1

Decimal round off issue

Posted: Thu Jul 25, 2013 10:39 am
by bond88
Hi,
I am facing an issue with decimal round off. I used an aggregator stage to calculate the sum of a decimal field. I tried changing it to float and again in transformer used Dfloat to Decimal function still it is rounding off decimal places. Can someone please guide me how can I restore decimals without getting round off?

Thank you,

Posted: Thu Jul 25, 2013 4:49 pm
by ray.wurlod
Investigate the environment variable APT_DECIMAL_INTERIM_SCALE, the "type" argument of the DFloatToDecimal() function, and the Ceil() and Floor() functions.