Business Intelligence Tutorial
In this exercise, you will define a primary key for the LOOKUP_MARKET,
LOOKUP_TIME, LOOKUP_PRODUCT, and LOOKUP_SCENARIO target tables.
To define the primary keys:
- Go to the Control Center window.
- Click View -> Refresh
- Find the LOOKUP_MARKET table in the list of tables for the TUTWHS
database. Right-click the table and click Alter.
The Alter Table notebook opens.
- Click the Primary Key tab. The Primary Key page
opens.
- In the Available columns list, select CITY_ID as the
primary key.
- Click > to move CITY_ID to the Primary key
columns list.
- Leave the Constraint name field empty, so that DB2 Universal
Database will generate a constraint name for you. A primary key can be
considered a constraint, because all values in the selected column must be
unique.

- Click OK to save your definition.
Follow the same steps to define primary keys for the other target
tables. Define:
- TIME_ID as the primary key for the LOOKUP_TIME table.
- PRODUCT_KEY as the primary key for the LOOKUP_PRODUCT table.
- SCENARIO_ID as the primary key for the LOOKUP_SCENARIO table.
[ Top of Page | Previous Page | Next Page | Table of Contents ]