What is the difference between olap and datawarehosue?
- 1 Answers
- 1046 Views
- I also Faced
- E-Mail Answers
Answer Posted / Gajendera Singh
OLAP (Online Analytical Processing) and Data Warehouse are two important components of Business Intelligence (BI) systems, but they serve different purposes. A Data Warehouse is a large database used for reporting and business intelligence, while OLAP provides the means to query and analyze data stored in the data warehouse. The main differences lie in their data modeling, access methods, and query types. Data warehouses use a star schema, normalized data, and SQL queries for data access. On the other hand, OLAP employs multidimensional modeling, denormalized data, and sophisticated analytical functions for complex data analysis.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Explain how to generate iqd file from framework manager?
What is the purpose of Dataware Control?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
