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


Please Help Members By Posting Answers For Below Questions

Explain in detail about type 2(scd),

598


How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

1892


What is the functional & architectural differences between business objects and web intelligence reports?

561


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1481


Explain what are the steps to do to use alerts in bo?

616






explain in detail about type 3?

631


in sap bi we have wad, then why we go for sap bo

2779


Explain what task is 98% of the required work of a business analyst?

604


Explain what is the difference between slice and dice and cross tab report?

608


What we need to discuss with designer before starting the universe designing.

1823


CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN

1749


what will be the contents for a functional requirements specifications

1790


Can we Save (save as) WEBI Doc as DESKI?

7078


U r project in which stage in implementation?

1950


Give some information on report bursting?

573