DSXchange

Hi All,

I have a column as decimal with length 22 and precision as 12 in sql server, in datastage for the column have many arithmetic function (ie addition, subtraction and division ) with same with length 22 and precision as 12, when I test the values with XL Sheet(precision as 12 ) with same operation whatever in datastage the result is not same , it getting round off after four values from the decimal point, please help in this, Thanks in advance.

Hi Friends,
This thing is happening when the column undergone on multiplication, please help As Soon As Possible.

Please post some examples and the derivations that you used.

In XL Sheet
12000000.000000000000 * 0.934448160535 = 11213377.926421400000

In Data stage
12000000.000000000000 * 0.934448160535 = 0011213377.926420000000

See there is round off after 4 digits from the decimal point

the derivation i used is [remaning_multiplier* factor_schedule]

i used this derivation in the stage variable all its datatype are Decimal(22,12)