Question - What is the difference between OLTP and OLAP?
Answer -
Followingare 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 |