Data warehouse deployment

1. List four major activities during data warehouse deployment. For two of these four activities, describe the key tasks.

2. Describe briefly the user acceptance procedure. Why is this important?

3. What are the significant considerations for the initial data load?

What are the two common block usage parameters? Using appropriate examples, describe how storage utilization may be improved in the data warehouse by setting these parameters properly. How are the settings different from OLTP systems? Why?

1. What topics should the users be trained on initially?

2. Give four common reasons for a pilot system.

3. What is a proof-of-concept pilot? Under what circumstances is this type of pilot suitable?

Solution: