topic Re: java.math.BigDecimal.<init>(Unknown Source) - error in tmap in Talend Studio

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

Anonymous — Tue, 29 Dec 2015 22:12:15 GMT

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)

Re: java.math.BigDecimal.(Unknown Source) - error in tmap

Anonymous — Wed, 30 Dec 2015 08:28:46 GMT

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

Re: java.math.BigDecimal.(Unknown Source) - error in tmap

Anonymous — Wed, 30 Dec 2015 15:37:34 GMT

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!