Scenario:How to use mapping parameter and variable in mapping ?
- 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.
- 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).
- In filter set deptno=$$v1 (that means only dept no 20 record will go to the target.)
- 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.