Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

FAQ: Does single (") handle correctly on IICS and using FileListconnector?
Answer
Yes, the single quotation is handled correctly using the FileList connector; however, it needs to be escaped to avoid truncation in the reading of the records present within the SRC file.

Example

Using the FileListconnecto​r on IICS the file seems read incorrectly. The task is completing successfully but only half of the records are read. If the (") is removed all the records are instead read correctly.

The corrector is behaving correctly, as the within the row there must be a " (initial) and " (end), otherwise, the connector is skipping the rows without mentioning in the log.

Also if there is only a single "  you would need the escape \"  otherwise it will not parse all records.


More Information

Applies To
Product(s): Cloud Data Integration
Product Version(s): Informatica Cloud
Database:
Operating System(s):
Other Software:

Reference

Attachments

Last Modified Date:1/9/2019 10:22 PMID:535158
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)