Data Architect Interview Question:

Explain me what is the difference between OLTP and OLAP?

Submitted by: Muhammad

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.
Submitted by: Muhammad