You can use a fixed-width flat file as a source in mappings and mapping tasks.
When you configure a Source transformation and select the fixed-width flat file type, you must select the most appropriate fixed-width file format to use based on the data in the fixed-width flat file. Ensure that the sample flat file only uses UTF-8 character set encoding.
Consider the following rules and guidelines for a fixed-width flat file:
•You cannot use a fixed-width flat file as a source in data transfer tasks.
•When you create the fixed-width file format, ensure that the sample file uses the following character as the new line symbol, based on the operating system where the Secure Agent is installed:
- For Linux, use \n character.
- For Windows, use \r\n character.
The source file must also use the same character as defined in the sample file.
•When you use a fixed-width flat file as a source, you cannot edit the metadata for the fields.
•When you read data of the date data type, you can read the date only up to milliseconds.