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
Issue coming when using IF conndtion for decimal columns
Moderators: chulett, rschirm, roy
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers