main purpose of aggregate awareness(not include make
possible of use of aggregate tables)
- 2 Answers
- 7792 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sai
Aggregate tables are used in the schema in oreder to
inprove the query performance.it is implemented by using
@aggregate_aware()function.these tables carries
precalculated aggregates(measures).it will improve query
performane,so we will get data fastly.refer this link to
know more:
http://www.dwoptimize.com/2007/09/aggregate-awareness.html
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / sonia
Aggregate Awareness is used to avoid having an object
multiple times, in different classes, for the fact table
and the aggregated table.
| Is This Answer Correct ? | 1 Yes | 8 No |
what is difference between global filter an query filter in web intelligence?
what is crystal reports?how to migrate them?
What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
3.what is alias?
5 Answers Business Intelligence Analytics, TCS,
Draw the architecture of traps?
what is meant by slowly changing dimensions?
what is meant by scorecards?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
How do you restrict access to rows of a database?
CAN A REPOSITORY CONTAINS REPORTS?
HOW TO CREATE THE HEIRARCHY IN WEBI OR DESKI NOT IN UNIVERSE LEVEL?
Teradata 
