A mapping can utilize parameters and variables to store information during the execution. Each parameter and variable is defined with specific data type and their main purpose is to provide increased development flexibility.
Variable
Variable is one it can be changing during session execution.
Ex: $$Flt cond>ok
Parameter
Parameter is one which is assigned with a fixed value and it cannot be changed during execution.
Parameter File
Parameter file is a text file which is located in informatica server, it is used to supply values to variables and parameters.
[Folder Name. Session Name]
Ex:
$$ Flt Cond= Sal>2000
$DB Connection_src=ora_src
$DB Connection_tgt=ora_tgt
Variable
Variable is one it can be changing during session execution.
Ex: $$Flt cond>ok
Parameter
Parameter is one which is assigned with a fixed value and it cannot be changed during execution.
Parameter File
Parameter file is a text file which is located in informatica server, it is used to supply values to variables and parameters.
[Folder Name. Session Name]
Ex:
$$ Flt Cond= Sal>2000
$DB Connection_src=ora_src
$DB Connection_tgt=ora_tgt
$$ src_owner=PM_EDW_MSTR_PROD
We can chieve parameters and variables in the mapping designer is like below
- Go to the mapping designer and then click on mappings
- In the mppings select Parameters& Variables.
- Declare parameters and variables
- Add new variable or parameter
