Business Intelligence Tutorial

Defining a star schema

In this exercise, you will define the star schema that is to contain the dimension and fact tables that you have defined in this tutorial.

To define a star schema:

  1. From the Data Warehouse Center, right-click the Warehouse Schemas folder.
  2. Click Define.

    The Define Warehouse Schema notebook opens.

  3. In the Name field, type the schema name:
    Tutorial Schema
    
  4. In the Administrator field, type your name as the contact for the schema.
  5. In the Description field, type the description of the schema:
    This is the TBC star schema
    
  6. Select the Use only one database check box.
  7. From the Warehouse target database list, select TUTWHS.

    Accept the rest of the values. For more information about the fields on this page, see the "Defining a warehouse schema" in the online help.

  8. Click OK to define the warehouse schema.

    The star schema is added to the tree underneath the Warehouse Schemas folder.


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