Page 1 of 1

rounding occurs when I mulitply fields together

Posted: Thu May 10, 2007 3:26 pm
by Bill_G
I am attempting to multiply 3 fields together in a transformer, however the output is rounded. for instance .45 shows as 0. all three fields are designated at Decimal (38,2) and my output field is also Decimal 38,2. The output is the same regardless if i write to a sequential file or to my oracle 9i table.

Thanks

Bill