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

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.