Informatica help

Informatica help and metadata report query

Session Execution

Session Execution

This page will show you all the Available reports for Session Execution, once you select a report name, it will open the report query page.

Copy and paste it to your PC and run it from Toad or any other DB tools you have.


Report Name Description
Connection Usage Details Displays sessions associated with a particular connection by repository by folder. This report is the first node in the analytic workflow associated with the Connection Usage primary report.
Currently Active Sessions By Server Displays the total number of sessions currently running by PowerCenter Server. This cached report is attached to the 5 Minute Refresh schedule, which refreshes every 5 minutes.
Failed Session Run Details(Yesterday) Displays session details, by repository and folder, for sessions that started yesterday and failed. This report is the first node in a workflow associated with the Failed Session Statistics (Yesterday) primary report.
Failed Session Statistics(Started Yesterday) Displays the total number of sessions that started yesterday and resulted in failed statuses by repository by folder. A session can fail due to read login failure or custom select statement error.
Server Load by Day of Week Displays the total number of sessions that ran and the total session run duration for any day of week in any given month of the year by server by repository. For example, all Mondays in September are represented in one row if that month had 4 Mondays.
Server Load(Yesterday) Displays the total number of sessions that ran and the total session run duration for yesterday by server by repository. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
Session Run Details Displays session run details for any start date by repository by folder. This is a primary report in an analytic workflow.
Sessions with Rejected Rows(Yesterday) Displays all sessions that started yesterday and had rejected rows by repository and folder. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
Target Table Load Analysis(Last Month) Displays the load statistics for each table for last month by repository by folder. This is a primary report in an analytic workflow.
Todays Failed Session Run Details Displays, by folder and repository, session details for all sessions that started today and failed. This report is the first node in the analytic workflow associated with the Todays Failed Session Statistics primary report.
Todays Failed Session Target Details Displays, by folder and repository, the target details for all target instances in sessions that started today and failed. This report is the second node in a workflow associated with the Todays Failed Session Statistics primary report.
Top 10 Sessions with Rejected Rows(Yesterday) Displays the top 10 sessions that had the most number of rows rejected. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
Top 5 Session Error Messages Displays by folder the top 5 most common error messages encountered by sessions.

Has one comment to “Session Execution”

You can leave a reply or Trackback this post.
  1. see this - Feb 07, 2017 Reply

    I absolutely love your site.. Excellent colors & theme. Did you build this web site yourself? Please reply back as I’m trying to create my very own blog and want to find out where you got this from or what the theme is called. Thanks!

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast