Data warehouse environment

1. Why do you think metadata is important in a data warehouse environment? Give a general explanation in one or two paragraphs.

2. Explain how metadata is critical for data warehouse development and administration.

1. Examine the concept that metadata is like a nerve center. Describe how the concept applies to the data warehouse environment.

2. List and describe three major reasons why metadata is vital for end-users.

You are the senior analyst responsible for the tools in the data warehouse of a large local bank with branches in only one state. Make a list of the types of tools you will provide for use in your data warehouse. Include tools for developers and users.

Describe the features you will be looking for in each tool type.

Solution: