Using mapping parameter and variable in mapping

Using mapping parameter and variable in mapping

Scenario:How to use mapping parameter and variable in mapping ?

Solution:

1.     Go to mapping then parameter and variable tab in the Informatica designer. Give name as $$v1, type choose parameter (You can also choose variable), data type as integer and give initial value as 20.

2.     Create a mapping as shown in the figure (I have considered a simple scenario where a particular department id will be filtered to the target).

3.     In filter set deptno=$$v1 (that means only dept no 20 record will go to the target.)

4.     Mapping parameter value can’t change throughout the session but variable can be changed. We can change variable value by using text file. I’ll show it in next scenario.