Business Intelligence Tutorial
In this exercise, you will add the dimension tables and fact tables
that you defined in this tutorial--the LOOKUP_PRODUCT, LOOKUP_SCENARIO,
LOOKUP_TIME, and FACT_TABLE tables--to the star schema.
To add the dimension tables and fact table to the star schema:
- Click the Add Data icon:

- Click the canvas at the spot where you want to place the tables.
The Add Data window opens.
- Expand the Warehouse Targets tree until you see a list of tables
underneath the Tables folder.
- Select the LOOKUP_MARKET table.
- Click > to add the LOOKUP_MARKET table to the
Selected source and target tables list.
- Repeat step 4 and step 5 to add the LOOKUP_PRODUCT, LOOKUP_SCENARIO,
LOOKUP_TIME, and FACT_TABLE tables.
- Click OK. The tables that you selected are displayed on
the window.
- Arrange the tables in the window so that the FACT_TABLE is in the center
and there is one LOOKUP table in each corner.
[ Top of Page | Previous Page | Next Page | Table of Contents ]