Email Triggered With Success Row count in Target Using informatica

Question

I need to trigger an email with all the stats like Count of Rows which are successfully loaded in the target, Failed rows count with the help of Informatica Powercenter. So where can I find this information for the Workflow and how can I used that information to trigger the email to respective people. There is an email task present in the Informatica which I am hoping I can use that.

Answer 1

You can use built-in session parameters to collect session run details, e.g.:

• $PMSessionName: Name of the Informatica session.
• $PMSourceName@TableName: Name of the source table name.
• $PMTargetName@TableName: Name of the target table name.
• $PMSourceQualifierName@numAffectedRows: Number of records returned from source.
• $PMTargetName@numAffectedRows: Number of record inserted/updated into the target table.
• $PMTargetName@numRejectedRows: Number of records error out in target.

Here's more info: http://powercenternotes.blogspot.com/2014/01/an-etl-framework-for-operational.html