Data Warehouse Manager Interview Question:

Tell me what is the difference between OLTP and OLAP?

Submitted by: Muhammad

Following are the differences between OLTP and OLAP:

OLTP:
Data is from original data source
Simple queries by users
Normalized small database
Fundamental business tasks

OLAP:
Data is from various data sources
Complex queries by system
De-normalized Large Database
Multi-dimensional business tasks
Submitted by: Muhammad