Data integration

1. Name at least six characteristics or features of a data warehouse.

2. Why is data integration required in a data warehouse, more so than in an operational application?

3. Every data structure in the data warehouse contains the ti

1. Explain data granularity and how it is applicable to the data warehouse.

2. How are the top-down and bottom-up approaches for building a data warehouse different? List the major types of architectures and highlight the features of any two of these.

1. Name any six different methods for information delivery.

2. What are the three major types of metadata in a data warehouse? Briefly mention the purpose of each type.

Solution: