In the next few lessons, you will focus on defining the Market dimension table in Tutorial business problem. In this lesson, you will define warehouse sources, which is a logical definition of the tables and files that will provide data to the Market dimension table. The Data Warehouse Center uses the specifications in the warehouse sources to access and select the data. You will define two warehouse sources that correspond to the source data that you viewed in Lesson 3, Browsing the source data:
If you are using source databases that are remote to the warehouse server, you must register the databases on the workstation that contains the warehouse server.