Informatica help

Informatica help and metadata report query

Operations reports

Operations reports

This page will show you all the Available reports for Operations reports, 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.

Session Execution

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.

Workflow Execution

Report Name Description
Workflow Run Details Displays the run statistics of all workflows by repository by folder. This is a primary report in an analytic workflow.
Workflow Task Run Details Displays the run statistics of all tasks in a workflow by repository by folder. This report is the first node in the analytic workflow associated with the Workflow Run Details primary report.
Worklet Run Details Displays the run statistics of all worklets by repository by folder.
Worklet Task Run Details Displays the run statistics of all tasks in a worklet by repository by folder.

2 comments to “Operations reports”

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

    Hello! Someone in my Facebook group shared this site with us so I came to take a look.
    I’m definitely loving the information. I’m
    bookmarking and will be tweeting this to my followers!

  2. Win - Feb 18, 2017

    Hello this is kind of of off topic but I was wanting to know if blogs use
    WYSIWYG editors or if you have to manually code with HTML. I’m starting
    a blog soon but have no coding knowledge so I wanted to get
    guidance from someone with experience. Any help would be enormously appreciated!

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