Explain What is the difference between OLAP and datawarehosue?
Submitted by: AdministratorDatawarehouse 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online Warehouse Concepts Job Interview Questions And Answers
Top Warehouse Concepts Questions
| ☺ | What is the difference between ODS and OLTP? |
| ☺ | Explain Is OLAP databases are called decision support system true/false? |
| ☺ | Explain What are non-additive facts in detail? |
| ☺ | Explain What is the difference between OLAP and datawarehosue? |
| ☺ | What is cubes? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
