Operational infrastructure of the data warehouse

1. What is the composition of the operational infrastructure of the data warehouse? Why is the operational infrastructure as important as the physical infrastructure?

2. List the major components of the physical infrastructure. Write two or three sentences to describe each component.

1. Briefly describe any six criteria you will use for selecting the operating system for your data warehouse.

2. What are the platform options for the staging area? Compare the options and mention the advantages and disadvantages.

You recently joined as the data extraction specialist on the data warehouse project team developing a conformed data mart for a local but progressive pharmacy. Make a detailed list of functions and services for data extraction, data transformation, and data staging.

Solution: