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.
Don't want to round off
Moderators: chulett, rschirm, roy
Don't want to round off
Ramesh Kumar.M
Especially happening in the multiplication part,
Hi Friends,
This thing is happening when the column undergone on multiplication, please help As Soon As Possible.
This thing is happening when the column undergone on multiplication, please help As Soon As Possible.
Ramesh Kumar.M
Hi Friend.
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)
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)
Ramesh Kumar.M