Oct 20, 2019 in Dataware house


What is the difference between OLTP and OLAP?

1 Answer

Oct 20, 2019
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
Click here to read more about Loan/Mortgage
Click here to read more about Insurance

Related questions

Mar 24 in SAP
Oct 23 in JAVA
Sep 27 in Web Hosting