Conversion error
Posted: Tue Apr 24, 2012 10:42 pm
My source is a fixed width file. In that i have a field with value as 000012345.00 in source. In the target it is decimal. so when i try to convert it to decimal with stringToDecimal function i'm getting the following warning and also in target the value is convrted as 000000.00,
APT_CombinedOperatorController,0:Conversion error calling conversion routine decimal_from_string data may have been lost
Please give me some suggestions inorder to get correct value in the output without any warnings.
Note: Source daatype- char(12)
Target datatype - decimal(9,2)
APT_CombinedOperatorController,0:Conversion error calling conversion routine decimal_from_string data may have been lost
Please give me some suggestions inorder to get correct value in the output without any warnings.
Note: Source daatype- char(12)
Target datatype - decimal(9,2)