Question

Make a file of direct and indirect

Answer 1

Answer:

File processing is one of the key features of informatica. Informatica provided a source Filetype option to specify the direct and indirect loading of source flat files into the target. Here we will see about direct, indirect source file type options and when to use them.

Direct Load of Flat File:

When you want to a load a single file into the target, then you can use the direct source filetype option. You can set the following source file properties in the mapping tab of the session:

Source File Directory: Enter the directory name where the source file resides.

Source Filename: Enter the name of the file to be loaded into the target.

Source Filetype: Specify the direct option when you want to load a single file into the target.

Example: Let say we want to load the employees source file (employees.dat) in the directory $PMSourceFileDir into the target, then source file properties to be configured in the session are:

Source File Directory: $PMSourceFileDir/

Source Filename: employees.dat

Source Filetype: Direct

Indirect Load of Flat file:

Let say 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 into a single target. Creating a mapping for each source file will be a tedious process. Informatica provides an easy option (indirect load) to handle this type of scenarios.

The indirect source file type option is used load the data from multiple source files that have the same structure and properties. The integration service reads each file sequentially and then loads the data into the target.

The process involved in specifying the indirect load options are 1.Creating a list file and 2.Configuring the file properties in session.