Informatica

How to Implement Indirect File Load in Informatica PowerCenter

Istock 498323425

Informatica PowerCenter is an ETL tool which is used to extract data from source and apply some transformation rules on the source data and load it to the target system.

Informatica indirect file load is an option used to load the data from multiple source files that have similar structure and properties. The integration service reads the source file sequentially and then loads the data into the target. Indirect file load is applicable only when we have flat file as a source. Only text file (.txt) as flat file is supported.

To understand the indirect file load better let’s take a scenario:

In an organization that has multiple branch offices, employee data for each branch is stored in a separate employee file. These files have the same structure and similar properties, and we want to load all these files into the same target. Creating a mapping for each source file would be a tedious process. Informatica provides a handy alternative of Indirect file load to handle this type of scenario.

 

1

 

2 1

 

The process involved in specifying the indirect file load is:

  1. Creating a list file
  2. Configuring the file properties in session.

Implementation of Indirect file load

Step 1: Create a list file (emp_list.txt) containing the names of all other source files e.g., emp_a.txt, emp_b.txt, emp_c.txt, emp_d.txt

3

Step 2: After importing the source into the designer, enable the port of Add Currently Processed Flat File Name port.

4

Step 3: After creating the workflow, change the session properties of source i.e., Source filetype to Indirect.

5

Step 4: While providing the source filename in the session provide list filename i.e., emp_list.txt

6

Step 5: While creating the target table add one more column i.e., FileName which will provide the source file name from where the data is imported.

7

This is how we successfully performed indirect file load in Informatica PowerCentre.

 

Happy Reading!!

Thoughts on “How to Implement Indirect File Load in Informatica PowerCenter”

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Sharad Jain, Senior Technical Consultant

Sharad is an ETL developer with a passion for innovation, learning, and Technology. He has 5 years of strong experience in ETL methodology for data transformation using Informatica PowerCenter and SQL with well-versed knowledge in technical and functional aspects of Order Management functionality.

More from this Author

Subscribe to the Weekly Blog Digest:

Sign Up
Categories
Follow Us
TwitterLinkedinFacebookYoutubeInstagram