Informatica help

Informatica help and metadata report query

PowerCenter Reports

PowerCenter Reports

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


Configuration Management reports

Deployment

Report Name Description
Deployment Details Displays, by group name, type, and creator, the details of the deployed objects by a particular deployment group. This report is the first node in the analytic workflow associated with the Deployment Group History primary report.
Deployment Group History Displays, by group, deployment groups and the dates they were deployed. It also displays the source and target repository names of the deployment group for all deployment dates. This is a primary report in an analytic workflow.

Object Version

Report Name Description
All Object Version History Displays all versions of an object by the date the object is saved in the repository. This is a stand-alone report.

Operations reports

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.

Powercenter Objects reports

Mappings

Report Name Description
All Objects Used in a Mapping Displays source, targets and all transformations used in a mapping by repository and folder.
Invalid Mapping sessions Displays sessions that are created for invalid mappings by repository and folder.
Invalid Mapping Targets Displays targets in an invalid mapping by repository and folder.
Invalid Mappings Displays invalid mappings by repository and folder.
Mapping List Displays mappings by repository and folder. It also displays properties of the mapping such as the number of sources used in a mapping, the number of transformations, and the number of targets.
Mapping Lookup Transformations Displays Lookup transformations used in a mapping by repository and folder.
Mapping Mapplets Displays mapplets used in a mapping by repository and folder.
Mapping Metadata Extensions Displays metadata extensions associated with a mapping and the properties of the metadata extensions.
Mapping Object-Level Connections Displays all transformations from source to target in a mapping and how they are connected to each other.
Mapping Port-Level Connections Displays all transformations from source to target in a mapping and how they are connected to each other through ports.
Mapping Shortcuts Displays mappings defined as a shortcut by repository and folder.
Mapping Source Field Details Displays column names for all sources by repository, folder, and mapping. It also displays properties of these columns such as datatype, precision, and length.
Mapping Sources Displays sources defined in a mapping by repository and folder.
Mapping Targets Displays targets defined in a mapping by repository and folder.
Mapping transformation Port Details Displays ports in a transformation by repository, folder, and mapping. It also displays properties of the ports. This report is the second node in a workflow associated with the Mapping List primary report.
Mapping transformations Displays transformations used in a mapping by repository and folder. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping with no sessions Displays mappings that do not have any sessions defined by repository and folder.
Source to Target Dependency Displays the data flow from the source to the target by repository and folder. The report lists all the source and target ports, the mappings in which the ports are connected, the transformation expression that show how data for the target port is derived.

Mapplet

Report Name Description
All Objects used in mapplet Displays all transformations used in a mapplet by repository and folder.
Mapplet List Displays mapplets available by repository and folder. It displays properties of the mapplet such as the number of sources used in a mapplet, the number of transformations, or the number of targets. This is a primary report in an analytic workflow.
Mapplet shortcuts Displays mapplets defined as a shortcut by repository and folder.
Mapplet Source Field details Displays column names for all sources by repository, folder, and mapplet. It also displays properties for these columns such as datatype, length, and precision.
Mapplet Transformations This is a subreport in the Mapplet Composite Report. This report displays transformations used in a mapplet by repository and folder.
Unused Mapplets in Mappings Displays mapplets defined in a folder but not used in any mapping in that folder.

I hope you will enjoy the content of my website.
Please leave me a comment below if you have any suggestion for improving

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