java.math.BigDecimal.<init>(Unknown Source) - error in tmap

[Anonymous]

Hi,
I'm encountering the below error in tmap and below is the screenshot of the tmap.
Can anyone please let me know if anything is wrong.
Exception in component tMap_12
disconnected
java.lang.NumberFormatException
    at java.math.BigDecimal.<init>(Unknown Source)
    at java.math.BigDecimal.<init>(Unknown Source)
    at routines.Numeric.convertImpliedDecimalFormat(Numeric.java:130)
    at drug.job01_12_t_msp_dly_0_1.JOB01_12_T_MSP_DLY.tFileInputMSPositional_2Process(JOB01_12_T_MSP_DLY.java:18615)

[Anonymous]

Hi,
There is something wrong with your conversion.
Could you please elaborate your case with an example with input and expected output values?
Do you want to convert your input string into BigDecimal value in tMap?
String-->BigDecimal
new java.math.BigDecimal(row1.columnName).
Best regards
Sabrina

[Anonymous]

Hi Sabrina,
We have the below input data coming from the source as the implied decimal format and we need to load the data using the Talend mappings into the oracle database.
I need to convert string into BigDecimal value in tmap.
Input row data : 498840035012T1   000000000000020090717000000000779020081128000000000420020041028               15344
Sample column data : 000000000000020090
I need to populate the database table in the decimal format as - 2.90
Thanks!