job

[Anonymous]

Hello All,

Can anyone please help me.my requirement is

1.input data type is decimal.

11.0000---->11.0000

12.123----->12.123

0.000---->this value will not be loaded

0----->this value should not be load in target

I was tried but I get an error i.e cannot convert for int(0) to decimal.

can any one please provide the suggestion and soluton.

thanks

[Jesperrekuh]

in your mapping just use int -> float which is a decimal

[manodwhb · Accepted solution]

you can use below function to convert bigdecimal.

new BigDecimal(row1.string_column)

[manodwhb]

did it help you?

[Anonymous]

THANK YOU GUYS .

For sharing your knowledge.

[manodwhb]

Please give kudos and click Accept the solution which one is helped.