Parameters and Variables

Parameter file it will supply the values to session level variables and mapping level variables.

Variables are of two types:

·        Session level variables

·        Mapping level variables

Session level variables are of four types:

·        $DBConnection_Source

·        $DBConnection_Target

·        $InputFile

·        $OutputFile

Mapping level variables are of two types:

·        Variable

·        Parameter

What is the difference between mapping level and session level variables?

Mapping level variables always starts with $$.

A session level variable always starts with $.

Flat File

Flat file is a collection of data in a file in the specific format.

Informatica can support two types of files

·        Delimiter

·        Fixed Width

In delimiter we need to specify the separator.

In fixed width we need to known about the format first. Means how many character to read for particular column.

In delimiter also it is necessary to know about the structure of the delimiter. Because to know about the headers.

If the file contains the header then in definition we need to skip the first row.

List file:

If you want to process multiple files with same structure. We don’t need multiple mapping and multiple sessions.

We can use one mapping one session using list file option.

First we need to create the list file for all the files. Then we can use this file in the main mapping.