Indirect File Type in Informatica

1. Direct Way — In this way you simply import all the required sources in the source analyzer and do the Union Transformation. The result of the Union Transformation are then uploaded in the target table.

2. Indirect Way — Here, you upload only a single source file. This source file is then mapped on to the target table. But then how do you get the data from other sources as well. Simple, when creating the session, instead of giving Direct at Source File Type. you need to give indirect and then when uploading the source file, you upload the file containing the path of all the files that are required.

This is simple concept. Instead of giving informatica the file, I am telling it that hey look this is the place where my sources are kept. So, go fetch them from there.

Now, try Indirect Uploading of source files.

Happy Learning 🙂