Integer to decimal

[halpavan2]

Hello All,

When i tried to multiply the data getting the following error.

Source data:-

2345
2346
2347
2348

In transformer i am doing this logic 2345*0.08

My source is Integer and while loading with decimal(8,7)

getting the following error

APT_CombinedOperatorController,0: APT_Decimal::ErrorBase: From: the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal..Record dropped.

Please suggest.

Thanks
Pavan

[ray.wurlod]

Decimal(8,7) has only one digit to the left of the decimal placeholder, and seven to the right of it. You need a larger precision (at least four more than the scale figure). You probably don't need scale of 7, since your multiplier only has two decimal places. So maybe Decimal(8,2) would suffice.