10.why we are going to data warehouse?
Answer Posted / 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.
Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we create universe with no cache??
What is aggregate table and aggregate fact table ... Any examples of both?
Explain what are the measure objects?
Explain is data mart?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain the difference between union and group?
How to execute the plsql procedure from the report by clicking with mouse?
can anybody tell me about complicated object you have created
Can more than 1 metric be applied on an analytic in business objects?
Explain difference between zabo and webi?
What is report template in b.o?
Explain how to schedule the report in b.o?
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Explain is there any default username & pwd for bo designer & supervisor?