Differentiate Between Oltp And Olap?

1.	Differentiate Between Oltp And Olap?
Answer» OLTP stands for ONLINE Transaction Process System OLTP is known for MAINTAINING transactional level data of the organization and generally, they are highly normalized. If it is OLTP route then it is GOING to be a star schema DESIGN. OLAP stands for Online Analytical process system. OLAP is known for a lot of ANALYSIS and fulfills reporting purposes. It is de-normalized form. If it is an OLAP route then it is going to be a snowflake schema design.

Answer»

OLTP stands for ONLINE Transaction Process System
OLTP is known for MAINTAINING transactional level data of the organization and generally, they are highly normalized. If it is OLTP route then it is GOING to be a star schema DESIGN.
OLAP stands for Online Analytical process system.
OLAP is known for a lot of ANALYSIS and fulfills reporting purposes. It is de-normalized form.
If it is an OLAP route then it is going to be a snowflake schema design.

Discussion