Business Intelligence Tutorial

Lesson 6. Defining warehouse sources

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:

Tutorial Relational Source
Corresponds to the GEOGRAPHIES source table in the DWCTBC database.

Tutorial File Source
Corresponds to the demographics file, which you will load into the warehouse database in a later lesson.

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.


[ Top of Page | Previous Page | Next Page | Table of Contents ]