Saturday, 8 September 2012

Session Log Parameter in Informatica

Session Log Parameter
The Workflow Manager provides a built-in session parameter named $PMSessionLogFile. Use $PMSessionLogFile in the session properties to change the name or location of the session log between runs. When you use $PMSessionLogFile in the session properties, define the parameter in the parameter file.  

Changing the Session Log Name
You can use $PMSessionLogFile to change the session log name between sessions. In the General Options settings of the Properties tab, enter $PMSessionLogFile in the Session Log Filename field. Then define $PMSessionLogFile in the parameter file. When the PowerCenter Server runs the session, it creates a session log in the directory listed in the Session Log File Directory field and names the session log as instructed by the parameter file. If a session log with the same name already exists, the PowerCenter Server overwrites the existing file.

For example, in a session, you leave Session Log File Directory set to its default value, the $PMSessionLogDir server variable. For Session Log File Name, you enter the session parameter $PMSessionLogFile. In the parameter file, you set $PMSessionLogFile to “TestRun.txt”. When you registered the PowerCenter Server, you defined $PMSessionLogDir as C:/Program Files/Informatica/PowerCenter Server/SessLogs. When the PowerCenter Server runs the session, it creates a session log named TextRun.txt in the C:/Program Files/Informatica/PowerCenter Server/SessLogs directory.  

Steps for Using $PMSessionLogFile
Use $PMSessionLogFile when you want to change the name and/or location of a session log between session runs.
To use the session log parameter:
  1. In the session properties, click the General Options settings of the Properties tab.
  2. Enter $PMSessionLogFile in the Session Log File field.
  3. If you want $PMSessionLogFile to represent both the session log name and directory, clear the Session Log File Directory field.
  4. Enter a parameter file and directory in the Parameter File Name field.
  5. Click OK.  
Before you run the session, create the parameter file in the specified directory and define $PMSessionLogFile.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

ShareThis