Answer / g.v.subramanyam

data warehouse is used for to store the large volumes of
data.it can be used for future forecasting.it is the
collection of key pieces of information that can be used for
to take the dession by the managers.

Answer / handy

The main aim of data warehouse is in analyzing the large
volumes of data so that it can be helpful in taking business
decisions

Answer / vams_gk

for reporting one day details also enough.but analysis
means we need comparision means we need some old data is
called historical data.the data ware house saves historical
data ,we con't to any data base manuplations.


where is in normal databases we arte able to maintain some
extent of data .after that for entering new data u need to
delete the old data.

BUT in Data ware house u are able to stote years of records
no need to delete the old data

Answer / nameer

Datawarehouse(OLAP):
To store historical or years of data, we use datawarehouse.
So it will be usefull for managerial people to analyse
theire current scenario with old one and take some usefull
decision in the future to improve their business.
We load the data into datawarehouse using some ETL tool
which is called datawarehousing where as in normal database
we use insert operation. in datawarehouse no delete,update
or insert operation is used. Only select operation is used.
It uses the dimensional modelling(star or snowflake) schema
which will speed up the retrieval of data comapred to
ordinary database.

WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?

4 Answers   Ericsson, Nokia,

---

1.what is the difference between development,maintainace and support in bo? 2.what is dynamic date prompt?Is it feasible to create dynamic date prompt in universe?what is the procedure? 3.how can u say that a report is complex ,simple or medium? 4.yesterday i had run the report it took max 30 sec to run the report.but today i came and refresh the same report ,more than two hours completed,still result not came?where is the issue might be?note that at universe and report level no issues?where u will go fro 3rd verification?

1 Answers   Accenture,

---

What is the slice and dice?

3 Answers  

---

how to schedule a report for even number dates?

2 Answers   HCL,

---

what is variable ?

3 Answers   Tech Mahindra,

---

---

what are the differences between web intelligence reports and crystal reports ?

3 Answers   AG Technologies,

---

Explain about a task that really tested your analytical abilities?

0 Answers  

---

WHAT ARE THE TYPES OF UNIVERSES?PLZ EXPLAIN IT

9 Answers   Business Intelligence Analytics, SRA,

---

Hi Can anyone tell me what is Divergence in Business Object Universe Designer. Thanks, Sheik

1 Answers  

---

how many reports have u created ? explain a few.

0 Answers   Bank Of America, TCS,

---

can any body tell me how to create Hyperlinks in BO XI R2?

2 Answers  

---

what is slice & dice?

3 Answers   Cognizant, Saama Tech, TCS,

---