Question

Describe the benefits of having an operational data warehouse (DWH), and the challenges of operating a DWH repository.

Answer 1

Answer:

The benefits of having the operational data ware-house are as follows:

• The single operational warehouse typically support various tactical and the strategical decisions.  
• It is subject oriented,volatile and integrated data warehousing in the system.
• The warehousing mainly allow the system to process the large complex data in more efficient manner.
• The operational warehouse are basically implemented for many business purposes.

The challenges of the operational warehouse repository are as follows:

• In the operational data warehouse there is large number of user expectations.
• The cost is the main challenge while designing the operational data warehousing as, it required efficient system in low cost.
• Choosing the efficient and correct type of the warehouse is the big challenge.