Difference between OLTP and DWH/DS/OLAP

                                                                                                                                                                      

Scenario:

Difference between OLTP and DWH/DS/OLAP

Solution:

OLTP	DWH/DSS/OLAP
OLTP maintains only current information.	OLAP contains full history.
It is a normalized structure.	It is a de-normalized structure.
Its volatile system.	Its non-volatile system.
It cannot be used for reporting purpose.	It’s a pure reporting system.
Since it is normalized structure so here it requires multiple joins to fetch the data.	Here it does not require much joins to fetch the data.
It’s not time variant.	Its time variant.
It’s a pure relational model.	It’s a dimensional model.