Decimal round off

[ag_ram]

Hi,

I have the value of input column as 99.99 whose metadata type is Decimal(5,3),this is further divided by 100 in the transformer stage and the output is coming as 1.0, the datatype in output is same as Decimal(5,3).But I require the value to be 0.999 and not as 1.0 without rounding off.Is there any way we can get the decimal value without rounding off.

[gopalreddy27]

chagne the data type

[gopalreddy27]

Hi,
You need to change the datatype to float on the target side.b/c it's not able to accomodate .9999 into 5,3

[ag_ram]

[quote="ag_ram"]Hi,

I changed the target to float at the intermediate step it's working fine,but my target is still decimal(5,3),so at the target it's getting rounded off.

[Maveric]

What is your target? If it is a database then change the meta data to float in the target and switch off RCP. I had this problem when converting decimal to float and this implicit conversion solved the problem. Try it and let us know.

[ag_ram]

Hi,
Ya Maveric my target is a database, you meant to swithoff the RCP in the datastage administrator right.
I have found one solution for this problem,that is after dividing the decimal by 100 convert the value to Float as suggested by gopal(Thanks ) and futher we can use a transformer stage to use a function DFloatToDecimal(column name,'trunc_zero'),this function will Discard any fractional digits to the right of the rightmost fractional digit supported in the destination, regardless of sign.Thus if target is Decimal(in my case) its working.

[mdan]

Hi,

I have the value of input column as 99.99 whose metadata type is Decimal(5,3),this is further divided by 100 in the transformer stage and the output is coming as 1.0, the datatype in output is same as Decimal(5,3).But I require the value to be 0.999 and not as 1.0 without rounding off.Is there any way we can get the decimal value without rounding off.

divide it by 100.000

dan