Business Intelligence Tutorial

Lesson 7. Defining warehouse targets

In this lesson, you will define warehouse targets. Warehouse targets identify the database and tables that the Data Warehouse Center is to use for your data warehouse. Generally, the target tables that are defined in the warehouse target are the dimension and fact tables in the star schema. However, the warehouse target might also include interim target tables that are used for data transformation.

In this lesson, you will define the Tutorial Targets warehouse target, which is a logical definition for the warehouse database you created in Lesson 2, Creating a warehouse database. Within the warehouse target, you will define the DEMOGRAPHICS_TARGET target table. This target table is the result of loading the Demographics file into the warehouse database.

In some cases, you can use the Data Warehouse Center to generate a target table based on SQL, rather than defining the target table yourself. The Market dimension requires a target table for the GEOGRAPHIES table, which you will join with the DEMOGRAPHICS_TARGET target table to produce the Market dimension table, called LOOKUP_MARKET. The Data Warehouse Center will generate the GEOGRAPHIES target table and LOOKUP_MARKET table in the next lesson.


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