Importing Flat File Sources in Test Data Management

Back Next

Import a Flat File into PowerCenter

You can import fixed-width and delimited flat file definitions that do not contain binary data.

When you import the definitions, 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. Copy the file to the source file location on the machine that hosts the PowerCenter Integration Service. The default location is

<Informatica installation directory>/server/infa_shared/srcfiles

When you create a file source, target, or lookup definition, you must define the properties of the file. The Flat File Import Wizard prompts you for the following file properties:

File name and location

File code page

File type

Column names and data types

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

Importing Flat File Sources in Test Data Management

Importing a Fixed-Width Flat File

Importing a Delimited Flat File

Formatting Datetime Data Types

Download Guide