Skip navigation

Log In

Forgot your password?
Don’t have an account? Sign Up

Sign Up

Access our rich network of apps, trials, and services.

Start the registration process by entering your email address below.

Already have an account? Log In

Mapping: Various scenarios of Flat File Sources

Free download

Posted by: Informatica Platform

Informatica PowerCenter mapping examples that demonstrate different scenarios of processing flat file data


In spite of the prominence of RDBMS storage, flat files will continue to be used to store and exchange data. While flat files provide simplicity, they do not provide sophisticated built-in functionality for data processing. Informatica PowerCenter offers a comprehensive set of features that makes it easy to work with flat file data.


Informatica PowerCenter can be configured to process both delimited and fixed width flat files. It also supports numeric, string and datetime datatypes for flat file sources and targets. When the Integration Service reads non-numeric data in a numeric column from a flat file, it drops the row and writes a message in the session log. Also, when the Integration Service reads non-datetime data in a datetime column from a flat file, it drops the row and writes a message in the session log.


Implementation Guidelines:

  • Template 1 - When data is sourced from a flat file it is not usually in any particular order. The Sorter transformation allows you to overcome flat file limitations in many scenarios. In this example it will be increase the efficiency of an aggregator by allowing its use in the sorted input mode.
  • Template 2 - join information from two heterogeneous sources: one database source and one flat file source.
  • Template 3 - This mapping creates 3 output files containing header, detail and trailer records that can be combined using a post-session command. The trailer record contains an extract date and row count that can be used for reconciliation purposes.


Note: The download is a zip file which contains the exported mapping in the XML format. After extracting the XML file it can be imported into the PowerCenter Designer client tool.

Key Features

Inbuilt partitioning feature works seamlessly with large flat files.

Dynamic file names for flat file targets.


PowerCenter version 9.1 and 9.5


Comments Comments (14)