Data Warehouse Implementation

1. What are the pros and cons of using a data warehouse?
2. What is the process to move data from the operational warehouse to the data warehouse?
3. Would you recommend the use of a data warehouse and why or why not?
4. What is a data cube and why is it important? How does it work?
5. What process would you recommend for implementing a data warehouse?

Sample Solution