Interested to Buy Any Domain ? << Click Here >> for more details...
10.why we are going to data warehouse?
- 4 Answers
- 11584 Views
- Satyam, TCS, I also Faced
- E-Mail Answers
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 aggregate table and aggregate fact table ... Any examples of both?
Explain what is the difference between slice and dice and cross tab report?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
How to generate the report from excel sheet?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
How would you format some text using css to be verdana and bold?
What is the difference between user and versatile user?
Did you face any problems while creating reports? Name? Solutions?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
What are the steps to be taken to schedule the report?
What task is 98% of the required work of a business analyst?
1. 101 vinay hyderabad 123 naresh usa 152 singh delhi 101 vinay usa 123 naresh mumbai 156 raju chennai From the above data we need to retrive current data in a report ? how and explain in detail ?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes
