File List – the indirect way

File List is a concept that provides you with an easier way to merge the data and load it into the target. As the name suggests, it is specifically related to flat files. This is an indirect way of passing the source file. We saw earlier that we can define the source path and the source file name under the mapping tab in the session task. There is another property in the session task called the Source File type, where you can select the Direct or Indirect option, as shown in the following screenshot:

File List – the indirect way

When we select Source filetype as Direct, Informatica directly goes to the defined Source file directory path and extracts ...

Get Learning Informatica PowerCenter 9.x now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.