Please rate this solution and share your feedback on Marketplace Website.

Name of Solution:

Informatica PowerCenter : Session log Parser

Business Requirement:

Parses your session logs after the session run and sends an email id with useful information

such as Session run stats, rejected rows etc.

Solution URL:

https://community.informatica.com/solutions/2175

Supported Versions:

PowerCenter 9.1 and 9.5

Description:

Session logs parser will parse the Informatica session logs that are written in Backward

Compatible mode. It takes a file list as input and creates a report on the source and target

load statistics. The file list should contain the list of session logs that need to be parsed.

After parsing log file it will create a report on the source and target load statistics.

It also contains email alert and reject row alert. By turning on the on email alert the report

will be emailed to the email ids that are provided. If rejects row alert is turned on, it will add

a generic alert in the report in case of any rejects on any of the sessions

Pre-Requisites / System Requirement:

This block required UNIX environment.

Download file contents:

1. Parser Files

2. Sample Files

Steps to implement the solution:

1. Copy or FTP the script and configuration file to the Unix machine and place it in the

script directory

a. Sesslog_Parser.cfg – Configuration file for the script

b. Sesslog_Parser.sh – Script to parse the log

Please rate this solution and share your feedback on Marketplace Website.

2. Enable the “Write Backward Compatible Session Log File” property in the session.

This will allow the script to parse the session logs directly.

3. The parser always takes one argument as input. It takes the file name of the file list

that contains the list of session logs that needs to be parsed. For example, create a

file with name “SessLogfilelist.txt”.

4. Enter all the session logs with absolute path that may need to parse as shown below.

5. Open the configuration file “Sesslog_Parser.cfg” and provide the required input.

Parameter Description Sample value

Infa_shared Your Infa shared directory /infadata/infa_shared

SessLogs

This directory will hold the

log,a file generated by the

parser.

/infadata/infa_shared/Scripts/Logs

Please rate this solution and share your feedback on Marketplace Website.

Rejected_Alert Its takes Y or N, case

sensitive. Setting this

parameter to you will

enable a special alert in

case of any rejects in the

session logs that are

parsed.

Y

Email_Alert Its takes Y or N, case

sensitive.Setting this

parameter to Y will enable

email alert, provided a

valid email address is

passed to Email_Id

parameter

Y

Email_Id Provide valid email id or

distribution list, if

Email_Alert parameter is

set to Y. Multiple email ids

can be provided as comma

separated values

prodsupport@abcxyz.com,

productionmgr@abcxyz.com

Email_Alert = Setting this parameter to Y(Upper case only) will enable email alerts,

provided a valid email address in Email_Id parameter

Please rate this solution and share your feedback on Marketplace Website.

6. Once the configuration is complete, the parser is ready to use and the syntax to

execute the parser is <scriptname filelist.txt> the execution may vary based on the

shell where you are executing.

Syntax: ./Sesslog_Parser.sh <filelist.txt>

7. Once the execution is complete you will see 2 files in the same directory

a. Gen_Logfile_Parser.log – Log file for the script, this will capture any errors /

warning /execution information about the script

b. <Filelist>_RunStats.txt – Report or the output of parsing.

8. If you open the <Filelist>_RunStats.txt it will have the parsed report from the

session log.

Please rate this solution and share your feedback on Marketplace Website.

9. The log file will contain any errors; the warning and the messages from the script will

be printed for debugging purpose. If the email alert feature is turned on you will also

receive an email with the parsed report as an attachment.

Please rate this solution and share your feedback on Marketplace Website.

10. If rejected alert turns on, the report will contain an alert with the number of rejected

tables.

YouTube Video on Importing and Configuring Workflows:

http://www.youtube.com/playlist?list=PLLRreK2jjjgWBQ4NPfp0QWTxYDvlnEqSJ

Other Useful links:

Mapping Bundles

Workflow Bundles

Informatica Tools Bundles

Informatica for Social Media Bundles

Debugging Tools Bundles

Visio Templates Bundles

B2B Templates and Projects Bundles

Data Quality Packs and Plans Bundles

Script Bundles