CODEWITHSUNDEEP
informaticasqldatatypesinformatica-powercenterinvalid-charactersflatfilereader
Prabakaran
Prabakaran

Reputation: 5

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

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?

Upvotes: 0

Views: 1681

Answers (1)

Maciejg
Maciejg

Reputation: 3353

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.

Upvotes: 1

Related Questions