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
how to prepare the documentation in business objects and where to get the requirement?
explain in detail about type 3?
Tell me a business scenario where I can achieve the data through MINUS only not through subquery.
Can more than 1 metric be applied on an analytic in business objects?
Differences between business objects and web intelligence reports?
What is the profile and package?
Explain is there any other repository domains rather than universe, security, document?
How to execute the plsql procedure from the report by clicking with mouse?
How to open a universe with out using the Designer ??
What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?
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 and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Which versions are used in the bo dashboard work?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain which versions are used in the bo dashboard work?