5 Replies Latest reply on Jun 9, 2020 2:22 PM by Jeremy Jensen

    Informatica Developer Model Repository Reporting Issue

    Zeeshan Saleem New Member

      I am looking to extract following information directly form Model repository using SQL or if any other pre built process available in Informatica.

       

      • No of Source Rows
      • No of rows Target
      • No of rows rejected
      • Error Message for Failed job.
      • Start Time
      • End Time

       

      This information available for each mapping session in workflow and we can send this information using email notification task. But we want to extract this information as bulk or email this information as bulk.

       

      We have 100+ jobs available in workflow session , so it would be difficult to add Notification against each session into the workflow.

       

      We are using Informatica developer and this information easily available in powercenter but we are unable to find this info in Model repository.

       

      Please guide if anyone know the better process.

        • 1. Re: Informatica Developer Model Repository Reporting Issue
          Akshada Sable Seasoned Veteran

          HI Zeeshan,

          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,
          Akshada

          • 2. Re: Informatica Developer Model Repository Reporting Issue
            Zeeshan Saleem New Member

            Hi,

             

            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.

             

            Thanks,

             

            Zeeshan Saleem

            • 3. Re: Informatica Developer Model Repository Reporting Issue
              Akshada Sable Seasoned Veteran

              Hi Zeeshan,

              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!

               

              Thanks,

              Akshada

              • 4. Re: Informatica Developer Model Repository Reporting Issue
                Zeeshan Saleem New Member

                Hi Akshada,

                 

                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 ?

                 

                Thanks,

                 

                Zeeshan Saleem

                • 5. Re: Informatica Developer Model Repository Reporting Issue
                  Jeremy Jensen Guru

                  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:

                   

                  Sample Retrieve Advanced Mapping Statistics

                   

                  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.

                  1 of 1 people found this helpful