Getting error: Invalid number['"] the row will be skipped

1.4k Views Asked by At

We have one mapping source as flatfile and target as oracle table. Source file comma delimited file. In some rows we use to get ' or " enclosed values. We set optional quotes as double in source definition. The session is running fine in 10.2 informatica but it is failing in 10.4 informatica version stating the error: Row[rownumber].field[column name]: Invalid number:['"]. The row will be skipped. The column specified here is int datatype. If run same job using same file it is working in 10.2 informatica. Any suggestions here?

1

There are 1 best solutions below

0
On

Read all data as strings, avoid implicit conversions. Any conversions shall be taken care of explicitely, in this case use TO_INTEGER function as described in the documentation. This will make capturing the error easier.

My guess is some trimming might be needed, or you'd need to remove the quotes.