Issue coming when using IF conndtion for decimal columns

[rajudx]

Hi,
In source input column defend as varchar(9) and while loading data into database using below if condition used in transformer stage, but while running job below error is coming .
error "APT_CombinedOperatorController,2: APT_Decimal::operator=: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal."
condition
--------
If to_tfm.MedAmt='~' Then 0.00
Else to_tfm.famNonParDedAmt

Output column defined as decimal (6,2) and values are coming +0.00 in input columns...
can someone please give the suggestion what is the issue and which need to be change for fixing above error.

Thanks,
Raju

[chulett]

Search the forums here for a significant portion of your error, like " the source decimal has even precision, but non-zero in the leading nybble" and you'll find 14 other times people have seen this one. Some are even marked as resolved, check those first.