March 1, 2019

Indirect loading for flat files of Informatica PowerCenter!

PROBLEM DESCRIPTION: Suppose from each country we are getting the Customers data in a separate file. These files have the same structure and same properties and we want to load all these files in to a single target. Creating a mapping for each source file will be tedious process. Informatica provides an easy option (indirect load) to handle this type of scenarios. Challenges to user/developer: In Informatica power center, the indirect source file type option is used to load the data from multiple sources files that have the same structure and properties. The integration service reads each file sequentially and then loads the data into target. The process involved in specifying the indirect load are Creating a list file and , Configuring the file properties in session.