Consider the example of filter transformation M_FILTER_PARA in which we want to project the details of employees belonging to detpno 10.
Define a variable $DEPTNO.
Variable represents a value that can be changed during mapping run.
 |
| Mapping Variable In Informatica |
Edit the filter transformation and click on Edit Properties Tab.
Variables tab (select SETVARIABLE)
 |
| Mapping Variable In Informatica |
Define a Workflow.
 |
| Mapping Variable In Informatica |
Right click the session and click on View Persistent Values…
 |
| Mapping Variable In Informatica |
Comments
Post a Comment