Warehouse Concepts Question:
Explain What is the difference between OLAP and datawarehosue?
Answer:
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.
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.
| Previous Question | Next Question |
| Explain What are non-additive facts in detail? | What is the difference between ODS and OLTP? |