What is the difference between OLTP and a Data warehouse?

1.	What is the difference between OLTP and a Data warehouse?
Answer» Indexes − OLTP system has only few indexes while in an OLAP system there are many indexes for performance optimization. Joins − In an OLTP system, large number of joins and data is normalized however in an OLAP system there are less joins and de-normalized. Aggregation − In an OLTP system data is not aggregated while in an OLAP database more aggregations are used.

Answer»

Indexes − OLTP system has only few indexes while in an OLAP system there are many indexes for performance optimization.

Joins − In an OLTP system, large number of joins and data is normalized however in an OLAP system there are less joins and de-normalized.

Aggregation − In an OLTP system data is not aggregated while in an OLAP database more aggregations are used.

Discussion