Hi All,
I'm trying to build some SQL queries to look at the statistics of the "high-level" load plan phases. We're working on improving the performance of our incremental loads, so we are interested in seeing/comparing current and former executions of the phase(s). For example, we have just moved to db links. I'd like a query to see just the following (from the screenshot below): 'Source Extract Phase', '1 General', '1 SDE Extract', '2 SDE Fact Group', and '2 SDE Dimension Group'. Name, Status, Duration, Start, and End are enough information to retrieve for the phases.
I've tried some queries, but haven't found anything to get exactly what I am looking for hear. I do have queries to get much finer details, like sessions, steps, and tasks. But those aren't what I want to see in this case.
Thank you & Regards,
Charles
OBIA 11.1.1.10.1 / ODI 11.1.1.9.0 / OBIEE 11.1.1.9.3