Oracle
1Z0-591 · Question #103
There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?
The correct answer is B. By opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab. 1. Configure the new source table to have the 'logical level' under the content set to 'Countries' (the summarized level) 2. Do the similiar setting for dimension table Now when user query the data at 'Counties' level, the query will be redirected to these summary table instead…
Creating Aggregate Tables
Question
There are two aggregate tables that are available for query. How would they be mapped into the logical data model so queries can use them?
Exhibit
Options
- ABy creating two new logical tables sources
- BBy opening the two logical Table Source dialog boxes and mapping the appropriate levels in the Content tab
- CBoth A and B
- DBy creating one new Logical Table Source
How the community answered
(19 responses)- A5% (1)
- B74% (14)
- C16% (3)
- D5% (1)
Explanation
- Configure the new source table to have the 'logical level' under the content set to 'Countries' (the summarized level) 2. Do the similiar setting for dimension table Now when user query the data at 'Counties' level, the query will be redirected to these summary table instead of the more detail fact table Note: Aggregate tables are Physical tables that store Aggregates of measures across multiple levels of a Hierarchy.
Topics
#aggregate tables#logical table source#content tab#level mapping
Community Discussion
No community discussion yet for this question.