Friday, September 23, 2011

Parameters in Informatica

There are parameters available in various levels like Session, Mapping, Workflow in Informatica

Mapping Parameter:
Mapping Parameters are basically a constant value which will define before running the session and that constant value will be used throughout the session.
E.g. $$LastRunDate( It can be identified with $$ sign)
We can define the parameter in parameter file like .par extension and we can use this parameter file in
mapping.

Here is the screenshot to declare mapping parameter.
Mapping designer>> mappings>> Parameter variable



Session Parameter:


Session Parameters are used to define the source or target database connections

No comments:

Post a Comment