Answer / hari priya

When we access the data frequently for reporting and when
the data is in huge quantity, we face delayed data retrival
problem.
To overcome this problem we can go for aggregates.

This improves the query performance.

Answer / vivek

you can check it from RSDDSTAT_OLAP table that which query
is being used mostly, and wht is the performance on that
basis you will create the aggregates on the cubes.
Aggregates are the small cubes through which the data
extraction is faster

What do u understand by Datawarehouse? How is it being used by different organisations?

2 Answers   Infosys,

---

What are the Oracle specific tuning should be done?

0 Answers  

---

where can i found more interview qustions on bw and bi

0 Answers  

---

HOW TO SUPRESS TEXT DATA WHILE LOADING MASTER DATA? HOW TO LOAD MASTER DATA WITH OUT CREATING INFOPACKAGE?

1 Answers  

---

What is the start routine?

3 Answers  

---

what is un assigned notes? how to define keyfigure as attribute? how to load text data with out attribute data?

1 Answers  

---

What internally happens when bw objects like info object, info cube or ods are created and activated?

0 Answers  

---

What is a pre-calculated web template?

1 Answers  

---

How do you analyse the data loading time ...today the loading time is 15 min.but tomorrow the same type of loading takes 3 hours..How do you analyse?

2 Answers   IBM,

---

how can u know the cube size? in detail show me u have screen shots

1 Answers   Rockwell, TCS,

---

what is performance tuning and the tools supposed to be used? and explain in detailed about aggregates, bw statistics and bi accelerator? uses of those tools?

0 Answers  

---

what is diffarences between QUEUE DELTA & DIRECT DELTA.

2 Answers  

---