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)
I can demote it but the value populated in targer is not correct. It is converted to 0000000.00 (total 9 zeros) and also as pandeesh said the lenght is exactly 12 charactes.