IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
Expand all | Collapse all

Optimize Database BAM_FACT_CUSTOM_V1

webMethods Community Member

webMethods Community Member11/24/15 06:00 AM

webMethods Community Member

webMethods Community Member12/08/15 11:48 AM

  • 1.  Optimize Database BAM_FACT_CUSTOM_V1

    Posted 11/20/15 10:15 AM

    Hello,

    I would like to do a report on Optimize.
    This report gonna contain the list of the consumed messages the last 24 hours.
    But to do so, i need some informations : The date and the trigger which consumed message
    I found the table BAM_FACT_CUSTOM_V1 which contains the list of consumed messages. In this table, i can use the field “DG_WAREHOUSE_DATE_DIM_ID” to determine the day where the message has been consumed.
    But my problem is that i need to find which trigger has consumed my message. I guess the only field which could help me is “Custom_Adapter_dim”, and i don’t find any correspondance in the other tables.

    Maybe somebody could help me with this ?

    Thanks per advance,


    #webMethods
    #BPM
    #webMethods-BPMS


  • 2.  RE: Optimize Database BAM_FACT_CUSTOM_V1

    Posted 11/24/15 06:00 AM


  • 3.  RE: Optimize Database BAM_FACT_CUSTOM_V1

    Posted 12/08/15 11:48 AM