Answers

Question and Answer:

  Home  Data Warehouse Concepts

⟩ Explain What is the difference between OLAP and datawarehosue?

Datawarehouse is the place where the data is stored for analyzing

where as OLAP is the process of analyzing the data,managing aggregations,

partitioning information into cubes for indepth visualization.

ODS:- A collection of tables created in the Data warehouse that maintains only current data.

OLTP:- Maintains the data only for transactions, these are designed for recording daily operations and transactions of a business.

 155 views

More Questions for you: