conerting a decimal(12,3) to decimal (9,2)

sravanthi · Post by **sravanthi** » Fri Sep 08, 2006 2:08 am

Hi

My source column data is coming as decimal(12,3) and i have to insert into target column with data type as decimal (9,2).

I have used decimalto decimal(column,"floor").It was not working.

Is there any other possible solution for this?

Thanks!

jayantthakore · Post by **jayantthakore** » Fri Sep 08, 2006 4:51 am

TRY THIS :
DecimalToDecimal(Column name,[2])
This should do it.

sravanthi · Post by **sravanthi** » Fri Sep 08, 2006 5:26 am

jayantthakore wrote:TRY THIS :
DecimalToDecimal(Column name,[2])
This should do it.

hi jayanth,

it is not accepting that expression.You mean 2 is for floor.

kumar_s · Post by **kumar_s** » Fri Sep 08, 2006 9:09 am

DecimalToDecimal should work. you have some option in Modify stage as well. I dont have access to DS right now to get you the right info. But you can optionally convert it to char and trim the 0's it if required and convert it back to decimal.

ray.wurlod · Post by **ray.wurlod** » Sun Sep 10, 2006 2:43 am

What will happen when the source value is too large to fit in a decimal[9,2] field?

Please post your exact decimal_to_decimal specification (I am assuming here that you are using a Modify stage).