what is aggregate navigation?
- 3 Answers
- 25399 Views
- Countrywide, CTS, HCL, I also Faced
- E-Mail Answers
Answer Posted / sam
To receive the performance benefit offered by an aggregate
schema, a query must be written to use the aggregate.
Rewriting the sample query was a simple matter of
substituting the name of the aggregate fact table for that
of the base fact table. This may be easy for technical
personnel, but can prove confusing for an end user. The
complexity grows as additional aggregate tables are added.
Technical and business users alike may err in assessing
which table will provide the best performance. And, if more
aggregate tables are added or old ones removed, existing
queries must be rewritten.
The key to avoiding these pitfalls lies in implementation
of an aggregate navigator.
A component of the data warehouse infrastructure, the
aggregate navigator assumes the task of rewriting user
queries to utilize aggregate tables.
Users and developers need only be concerned with the base
schema. At runtime, the aggregate navigator redirects the
query to the most efficient aggregate schema.
| Is This Answer Correct ? | 6 Yes | 4 No |
Post New Answer View All Answers
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.
what are the day to day activities of BO administrator ?
What is the difference between absolute and relative div positioning?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
what is xcelsius architecture?
What we need to discuss with designer before starting the universe designing.
What is package in BO
What are the join problems comes appart from loop,chasm & fan Traps
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
How to execute the plsql procedure from the report by clicking with mouse?
How would you format some text using css to be verdana and bold?
8. How much supervision have you typically received in your previous job?
Explain is data mart?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
