You can import fixed-width and delimited flat file definitions that do not contain binary data. When importing the definition, the file must be in a directory local to the client machine. In addition, the PowerCenter Integration Service must be able to access all source files during the session.
When you create a file source, target, or lookup definition, you must define the properties of the file. The Flat File Wizard prompts you for the following file properties:
File name and location
File code page
File type
Column names and datatypes
Number of header rows in the file
Column size and null characters for fixed-width files
Delimiter types, quote character, and escape character for delimited files