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

how to prepare the documentation in business objects and where to get the requirement?

2155


explain in detail about type 3?

953


Tell me a business scenario where I can achieve the data through MINUS only not through subquery.

3016


Can more than 1 metric be applied on an analytic in business objects?

2099


Differences between business objects and web intelligence reports?

1127


What is the profile and package?

2251


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

1008


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

1073


How to open a universe with out using the Designer ??

7455


What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2078


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.

3406


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

1210


Which versions are used in the bo dashboard work?

982


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

1790


Explain which versions are used in the bo dashboard work?

1039