Explain two reasons why feeding data into OLAP system directly from the source operational system is not recommended?
Submitted by: AdministratorBusiness Users needed to build queries that summarized the data and fed management reports. Such queries, were extremely slow because they usually summarize large amounts of data, while sharing the database engine with every day operations,
Reason1
which in turn adversely affected the performance of operational systems.
Reason2
Delay in strategic planning of the enterprise.
The solution was, therefore, to separate the data used for reporting and decision
making from the operational systems. Hence, data warehouses were designed and built to house this kind of data so that it can be used later in the strategic planning of the enterprise.
Submitted by: Administrator
Reason1
which in turn adversely affected the performance of operational systems.
Reason2
Delay in strategic planning of the enterprise.
The solution was, therefore, to separate the data used for reporting and decision
making from the operational systems. Hence, data warehouses were designed and built to house this kind of data so that it can be used later in the strategic planning of the enterprise.
Submitted by: Administrator
Read Online Analysis Services Job Interview Questions And Answers
Top Analysis Services Questions
☺ | Explain the difference between analysis and synthesis? |
☺ | Explain two reasons why feeding data into OLAP system directly from the source operational system is not recommended? |
☺ | Give details of the various approaches of software evaluation? |
☺ | Tell me what are the tools used for data analysis in DHW especially where DataStage is being used as the ETL tool? |
☺ | Explain ATM Security level? |
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. |