Using the Workflow Manager Screen – Advanced - Learning Informatica PowerCenter 9.x - page 240

option. When you select Source filetype as Indirect , Informatica reads the data from the
file mentioned indirectly. Let's look at an example to understand this concept.
Consider that you have been provided with three source files with the same structure but
different data. The names of the source files are C:/FILE1.txt , D:/FILE2.txt,
and E:/FILE3.txt . The requirement is to merge the data into a target file. You can
achieve the requirement using union transformation, which we are going to discuss in
Chapter 7 , The Lifeline of Informatica - Transformations , in the Union transformations
section. The indirect file type concept helps you achieve the same requirement in an easier
way. Remember to implement the File List concept—the files you are willing to merge
should have exactly the same data type. To implement the file list, we will create another
file with a name such as FILE_LIST.txt . Then, add the names of all the three files
with the path in FILE_LIST.txt , as follows:
Define the properties in the session task for Indirect file type, as shown in the following
screenshot:
The mapping will be as simple as Source - Source Qualifier - Target.