query to retrieve workflow details from repository tables in informatica?

I need to get workflow details like wf name, objects used, run time and throughput from repository tables in informatica. can you help with the query?

1 answer

  • answered 2022-03-02 13:44 Koushik Roy

    This will give you workflow run details -

    select
    SUBJECT_AREA folder_name,
    WORKFLOW_NAME,
    START_TIME,
    END_TIME,
    round((END_TIME-START_TIME) *24*60,2) time_taken_min, 
    RUN_ERR_CODE,
    RUN_ERR_MSG,,
    RUN_STATUS_CODE
    from 
    REP_WFLOW_RUN
    order by 2 ,3
    

    You can not get through put for a workfolw. Its applicable for only for wprkflows. If you need session log, session details, pls query in REP_SESS_LOG.

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum