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

Answer / sonia

Aggregate Awareness is used to avoid having an object
multiple times, in different classes, for the fact table
and the aggregated table.

When N reports are scheduled for N users, How does the BCA process /know to which user the report needs to be sent?

4 Answers   Wipro,

---

WHO ARE THE USERS OF THE REPOSITORY?

6 Answers   AG Technologies,

---

What is the Difference b/w Server based Ranking and normal Ranking?

1 Answers  

---

How we will see which trap(Chasm trap or Fantrap) was used in the Universe ?

2 Answers   Wipro,

---

how to overcome overflow of data in a report

6 Answers  

---

Why do we need Three environments Like DEV, UAT, PROD. Need detailed answer please

1 Answers   HCL,

---

WHAT DOES SQL TAB CONTAIN?

1 Answers   Polaris,

---

1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

4 Answers   KPIT, TCS,

---

What three things do you consider to be the most important factors for a manager?

0 Answers  

---

what r the disadvanges in boxir2

3 Answers   Accenture,

---

Draw the architecture of traps?

3 Answers   Wipro,

---

How to Shedule the reports in Xi R2

3 Answers   iFlex,

---