Following are the differences between OLTP and OLAP:
OLTP OLAP
Data is from original data source Data is from various data sources
Simple queries by users Complex queries by system
Normalized small database De-normalized Large Database
Fundamental business tasks Multi-dimensional business tasks
