Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2268


Explain is there any other repository domains rather than universe, security, document?

1097


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1059


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2297


1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?

3580


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

1107


Explain how to execute the plsql procedure from the report by clicking with mouse?

1054


what is document design in boxi,have u participate in that

2190


how get the grand total in master-detail report?

2236


When to use local filter and when to use global filter?

1002


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

1156


Explain what three things do you consider to be the most important factors for a manager?

1014


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2915


Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1956


What are the steps to be taken to schedule the report?

966