Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 63 Insurance
- 536.4K On-Premises Infrastructure
- 138.3K Analytics Software
- 38.6K Application Development Software
- 5.8K Cloud Platform
- 109.5K Database Software
- 17.5K Enterprise Manager
- 8.8K Hardware
- 71.1K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
DAC Repository database question

658640
Member Posts: 5
I 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
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
Answers
-
May be you can ask your question in this forum: 3412
Hope they can help you better over there! -
Thanks. I'll see what I can find over there.
This discussion has been closed.