Session parameters are like maping parameters,represent values you might want to change between sessions such as database connections or source files. Server manager also allows you to create userdefined session parameters.Following are user defined session parameters:- Database connections Source file names: use this parameter when you want to change the name or location of session source file between session runs. Target file name : Use this parameter when you want to change the name or location of session target file between session runs. Reject file name : Use this parameter when you want to change the name or location of session reject files between session runs.
By using Session parameters we can reuse the session how many times you want. The main purpose of session parameter it represents connection path to a database system. we can reuse the different types of databases.
If you want to use session parameter we have to follow the following procedure 1. Double click the session and select mapping tab in the mapping tab select target connection, in the target connection select writer property click on Radio Button USE Connection Variable and write the connection variable $$<Connection Variable>.
After that create a parameter file with .txt or .prm using the following syntax