What is the difference between olap and datawarehosue?
- 1 Answers
- 1044 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is surrogate key?
How to import vsam files from source to target. Do we need a special plugin?
What is Star Schema?
Explain what is the extension of file to save template?
What is data merging, data cleansing and sampling?
What is a data warehousing?
What is the extension of file to save template?
What is perform recovery?
What is "method/1"?
How to handle time period attribute for time dependent data?? a.)add time period as a part of pk b.)add time period simply and make it nullablec.)add time period simply and make it not null.
What is an er diagram?
Where the cache files stored?
Teradata 
