Just stumbled over the problem how to successfully skip trailing blanks in my fixed length flat file and how to have a CR/LF line feed instead of the UNIX one.
As a rookie in Informatica, I naturally opened my flat file definition in the PowerCenter Designer and configured the flat file properly using Advanced Options:
After selecting the Advanced button on the lower right corner, the following dialog appears where you can set the configuration:
To enable the settings in the workflow, you have to configure the flat file in the session.
- Open the session to be configured
- Go to the Mapping tab
- Select the source from the Sources tree on the left of the dialog
- Select the link Set File Properties (see screenshot)
The following dialog appears:
Make sure that you have selected the correct instance on the left and select the Advanced button. The following dialog appears:
This dialog looks familiar to the dialog in PowerCenter Designer. Configure it properly (e.g. Number of bytes to skip between records to 2 for Windows / DOS files and to 1 for UNIX files).