If you are looking for the information like number of rows processed, number of source rows, number of rejected records,start time, end time of all the mappings, you can make use of the Informatica monitoring console.
Below is a reference screenshot of the Monitoring console UI for one of the mapping statistics:
This provide a consolidated UI to track all these details. It is not advisable to directly query the MRS to fetch this information and hence you can use the monitoring UI where all this information is readily available.
Refer 514339 to know more on how to enable monitoring.
Thanks for your advise but our client requirement is to generate custom report on all the executed jobs.
We have more the 1000 + jobs so it would be difficult to go on monitoring tool to check each job individually.
Please suggest if we can get this information directly from informatica source repository or from some other location.
It is not advisable to directly query the MRS. There are few readily available views which might help you here.
Refer Model Repository (MRX) Views for more details on this.
In addition to this, note that all this Information(viewed i the monitoring console in historical statistics) can further be exported to Excel and used as a report.
Hope this helps!
This information is very useful but somehow we are unable to map this information on provided requirements.
I understand, it is not recommended to access repository tables but we will not be able to achieve desire task without access that. (So please provide views or tables if you know any )
Or is there any pre-build process which read logs and extract this information ?
1 of 1 people found this helpful
Zeeshan - something that might be worth looking at is the 10.4 platform. There is a new service called the Rest Operations Hub Service. From what I can tell, it allows you to query run details from a REST call:
This might meet your use case - if you can integrate the rest call into what ever reporting solution you've got.
This came out originally in 10.2.2 BDE - but it looks like Informatica is merging the product lines together with v 10.4. I am not too sure about that, but if you're running on 10.4 or can possibly upgrade to 10.4 and configure this service, you might be able to get the statistics you need for processes running on a data integration service.