1 Reply Latest reply on Oct 14, 2021 12:17 AM by Ashwini Ramakrishna

    How to figure out throughput in CDI

    Gopinath Vijayan Guru

      Hello

       

      In Power center we can check the  monitor for throughput . How to check in Data Integration jobs?

      I see total run time, total records but not throughput

       

      Thanks,

      Gopi

        • 1. Re: How to figure out throughput in CDI
          Ashwini Ramakrishna Guru

          Hello Gopinath,

           

          As in PC you cannot find directly in the monitor the stats but in the session log of a completed process you can find a section called "LOAD SUMMARY". In there you will have the subsection "***** RUN INFO FOR TGT LOAD ORDER GROUP [1], CONCURRENT SET [1] *****" under which you can see three threads. Each of these threads represents the Reader, Transformation and Writer respectively. These sections also contain information about three factors:

           

          "Total Run Time" = time this thread was loaded

           

          "Total Idle Time" = time this thread was loaded but waiting for other components

           

          From this information, you can tell if the bottleneck is either the source (Reader), the transformations or the target (Writer). Judging on the Busy Percentage you can also estimate if the process is waiting on an external endpoint (low Busy Percentage).

          2 of 2 people found this helpful