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.