Data loading and index creation

1. Name four key issues to be considered while planning for a data warehouse.

2. Explain the difference between the top-down and bottom-up approaches for building data warehouses. Do you have a preference? If so, why?

1. As the senior analyst on the data warehouse project of a large retail chain, you are responsible for improving data visualization of the output results. Make a list of your recommendations.

2. Explain how and why parallel processing can improve performance for data loading and index creation.

Your company is in the business of renting DVDs and video tapes. The company has recently entered into e-business and the senior management wants to make the existing data warehouse Web-enabled.

List and describe any three of the major tasks required for satisfying the management’s directive.

 

Solution: