Interested to Buy Any Domain ? << Click Here >> for more details...
main purpose of aggregate awareness(not include make
possible of use of aggregate tables)
- 2 Answers
- 8402 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 a join? Explain different types of joins?
There are 2 types of strategies are there? 1. Built-in Strategy 2. External Strategy can you please explain them in complete that what are these? Thanks in Advance
5.what is slowly changing dimension ?
What is the use of Surrogate key in BO?
What is the difference between datawarehousing and businessintelligence?
HOW YOU WORKED WITH MULTIPLE DATA SOURCES?IF YES ?HOW DO YOU LINK THEM?
Types of universes in business objects?
5.what is LOV? where it is store?
how to test the reports if there are multiple sql statements?i,e if there is 1 single sql statement we can copy it and paste it in TOAD or someother tools to test it but if we have multiple sql statements in a single query????
what is zero client and thin client ?
how we improve the performance of report and universe?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Teradata 
