When you import a flat file in the Designer, you can select the code page of the file. The Designer lists the five code pages you have most recently selected. Then it lists all remaining code pages in alphabetical order.
The code page represents the code page of the
data
contained in the file. When you configure the file definition, specify delimiters, null characters, and escape characters that are supported by the code page.
For delimited files, specify delimiters, optional quotes, and escape characters that are contained in the source file code page. For fixed-width files, specify null characters as either a binary value from 0 to 255 or a character from the selected code page.
When you configure the flat file definition, use delimiters, escape characters, and null characters that are valid in the code page necessary to run a workflow.
ASCII data movement mode.
Use characters from the code page you define for the flat file. Any 8-bit characters you specified in previous versions of PowerCenter are still valid.
Unicode data movement mode.
Use characters from the code page you define for the flat file.