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,