Business Intelligence Tutorial
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:
- From the Data Warehouse Center, right-click the Warehouse
Schemas folder.
- Click Define.
The Define Warehouse Schema notebook opens.
- In the Name field, type the schema name:
Tutorial Schema
- In the Administrator field, type your name as the contact for
the schema.
- In the Description field, type the description of the
schema:
This is the TBC star schema
- Select the Use only one database check box.
- 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.
- 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 ]