in Dataware house by

What is the difference between OLTP and OLAP?

▼ Show 1 Answer

0 votes
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
Learn More with Madanswer

Related questions

0 votes
asked Mar 29, 2020 in SAP by amita rallin