Defining a warehouse primary key

These steps are part of the larger task of Defining a warehouse source table, Defining a warehouse source view, or Defining a warehouse target table. When you complete the steps for Defining a warehouse primary key, return to Defining a warehouse source table, Defining a warehouse source view, or Defining a warehouse target table.

To define a warehouse primary key:

1. On the Warehouse Primary Key page, select the column from the Available columns list that you want to define as a warehouse primary key, and click >. The column that you select is moved to the Warehouse Primary key columns list. The order of the columns that you specify is significant because the database manager uses the warehouse primary key for efficient access to table data.

   To include all of the columns in the Available columns list, click >>.

2. Optional: To remove a column from the warehouse primary key definition, select the column from the Warehouse Primary key columns list and click <.

   To remove all of the columns from the warehouse primary key definition, click <<.

3. Optional: Type a name for the warehouse primary key constraint for the table in the Constraint name field. You must move a column to the Warehouse Primary Key columns list in order to edit this field.

   The Data Warehouse Center generates a default name for the warehouse primary key constraint.

Return to Defining a warehouse source table, Defining a warehouse source view, or Defining a warehouse target table.