DAC Repository database question
658640Sep 8 2008 — edited Sep 9 2008I am trying to write a query that will provide me a list of Subject Areas and their corresponding Tasks. The same list you would see in the "Tasks" tab in the DAC Client Design view for a specific Subject Area. This is in our test environment with the 7.9.5 OBI Apps.
I am not very familiar with the DAC database tables but through the help files, information I've found online, and a little bit of hacking I believe the tables I need are:
W_ETL_SA
W_ETL_STEP
W_ETL_SA_STEP
When executing the following query I do not get the full set of results.
SELECT
W_ETL_SA.name as SA_Name
,W_ETL_STEP.name as STEP_Name
FROM
W_ETL_SA
,W_ETL_STEP
,W_ETL_SA_STEP
WHERE
W_ETL_SA_STEP.SA_WID = W_ETL_SA.ROW_WID
AND W_ETL_SA_STEP.STEP_WID = W_ETL_STEP.ROW_WID
The W_ETL_SA_STEP table has 69 distinct SA_WID values but only 5 of them correspond to records in the W_ETL_SA table.
I've been able to run a similar query for Execution Plans and their corresponding Subject areas with the W_ETL_DEFN_SA, and a query for Execution Plans and their corresponding Tasks with W_ETL_DEFN_STEP.
Any ideas why this query does not work? Have I misunderstood the purpose of the W_ETL_SA_STEP table?
Thanks is advance
Tom