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?
Asked
Active
Viewed 1,104 times
0
-
Run it in verbose mode to see what exactly is the issue. I think some non numeric data is coming and infa cant process it. practice is to change all columns to a string datatype and then convert them next expression transformation. – Koushik Roy Oct 08 '21 at 03:57
-
We have added MatchQuotesPastEndOfLine=Yes and its worked fine. Thank you! – Prabakaran Oct 22 '21 at 18:34
-
i know it resolved your issue but i feel like the solution form Maciejg is better. – Koushik Roy Oct 23 '21 at 03:21
1 Answers
1
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.
Maciejg
- 3,088
- 1
- 17
- 30