Data Warehousing Question: Download Data Warehousing PDF
What is the difference between OLAP and OLTP?
Answer:
OLAP stands for online analytical processing. In this, we have access to live data. This process contains historical information to analyze. Data needs to be integrated. We can create reports that are multi-dimensional, supported by time-based analysis and ideal for applications with unpredictable, ad hoc query requirements.OLTP stands for online transaction processing. OLTP databases are fully normalized and are designed for consistently store operational data, one transaction at a time. It performs day-to -day operations and not support historical data.
| Previous Question | Next Question |
| What are the different approaches used by Optimizer in choosing an execution plan? | What is the difference between aggregate table and materialized view? |