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
what is xcelsius architecture?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
Explain how many universes can be created in a project?
How would you format some text using css to be verdana and bold?
What would you consider as your biggest achievement and why?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
How many universes can be created in a project?
Explain the difference between union and group?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
What three things do you consider to be the most important factors for a manager?
What we need to discuss with designer before starting the universe designing.
What is the difference between user and versatile user?
what is document design in boxi,have u participate in that
What is thumbnail?