Problem
PowerCenter ignores by default that a linebreak might be enclosed in quotes such that it will consider a record with linebreaks in fileds as several records. The field port relation suffers a shift such that wrong content ends in ports.Workaround solution
https://community.informatica.com/thread/28705 provides a solution by creating a custom property in the integration service admin console with name = MatchQuotesPastEndOfLine and value = Yes (path displayed by in attached screen shot).One can work around this by creating a session custom property (see the other attached screen shot), but this seems to be a rather frequent problem such that it be more robust if setup as IS custom property.
It seems sensible to provide the other shown session custom property also as IS custom property for the same reason.


Is the same as http://thiemos-powercenter.blogspot.ch/2016/11/problem-you-load-delimited-file-but.html
AntwortenLöschen