Data Architect Question:
Download Job Interview Questions and Answers PDF
Explain me what is the difference between OLTP and OLAP?
Answer:
OLTP is the transaction system that collects business data. Whereas OLAP is the reporting and analysis system on that data.
OLTP systems are optimized for INSERT, UPDATE operations and therefore highly normalized. On the other hand, OLAP systems are deliberately denormalized for fast data retrieval through SELECT operations.
OLTP systems are optimized for INSERT, UPDATE operations and therefore highly normalized. On the other hand, OLAP systems are deliberately denormalized for fast data retrieval through SELECT operations.
Download Data Architect Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can you explain me what is dimension? | What is the conceptual model? |