Business Intelligence Tutorial

Adding tables to the schema

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:

  1. Click the Add Data icon:
    Figure alldata not displayed.
  2. Click the canvas at the spot where you want to place the tables.

    The Add Data window opens.

  3. Expand the Warehouse Targets tree until you see a list of tables underneath the Tables folder.
  4. Select the LOOKUP_MARKET table.
  5. Click > to add the LOOKUP_MARKET table to the Selected source and target tables list.
  6. Repeat step 4 and step 5 to add the LOOKUP_PRODUCT, LOOKUP_SCENARIO, LOOKUP_TIME, and FACT_TABLE tables.
  7. Click OK. The tables that you selected are displayed on the window.
  8. 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 ]