In this lesson, you will define warehouse targets. Warehouse targets identify the database and tables that the Data Warehouse Center is to use for your data warehouse. Generally, the target tables that are defined in the warehouse target are also used as the dimension and fact tables in the star schema. However, the warehouse target might also include interim target tables that are used for data transformation.
In this lesson, you will define the Tutorial Targets warehouse target, which is a logical definition for the warehouse database that you created in Creating a warehouse database. Within the warehouse target, you will define the DEMOGRAPHICS_TARGET target table.
You can also specify that the Data Warehouse Center is to generate the target table. This step will be covered in the next lesson.
In this exercise, you will define the Tutorial Targets warehouse target, which is a logical definition for the TUTWHS database that you created in Creating a warehouse database.
To define the warehouse target:
The Define Warehouse Target notebook opens.
Tutorial Targets
Warehouse for the TBC company
TUTWHS
You are creating the target database in the default system, so you can skip the System name field.
Use the default values for the rest of the controls on the page.
Adding the target to the warehouse group authorizes the users in the group (in this case, you) to create steps that use this warehouse target.
In this exercise you will define the DEMOGRAPHICS_TARGET table within the Tutorial Targets warehouse target.
To define a warehouse target table:
The Define Warehouse Target Table notebook opens, and you can define the
DEMOGRAPHICS_TARGET table.
DEMOGRAPHICS_TARGET
Because you are creating the tables in the default table space, you can skip the Table space and Index table space lists.
Demographics data for sales regions
Demographics Target
The Data Warehouse Center will create this table when the step that loads the Demographic data runs.
You use this option when you want the Data Warehouse Center to create the target table. Otherwise, you can use a target table that is already defined.
This check box specifies that anyone who has access to the database has access to the table.
The Part of an OLAP schema check box indicates that the table is a dimension table or fact table that is to be exported to OLAP Integration Server. For more information about exporting to OLAP Integration Server, see Creating a star schema from within the Data Warehouse Center.
Skip the rest of the controls on the page. For more information about them, see "Defining a warehouse target table" in the online help.
Leave the Define Warehouse Target Table window open and go on to the next exercise.
To add columns to the target table:
A row is added to the list, and you can define the State column, which is one of the main values for the table.
Skip the Precision and Scale columns because they apply to decimal data only.
Name | Data type | Length | Allow nulls | Business name |
---|---|---|---|---|
CITY | CHAR | 50 | Clear the Nullable check box | City |
POPULATION | INTEGER | N/A | Clear the Nullable check box | Population |
Skip the rest of the notebook. You will use the DB2 Control Center and Data Warehouse Center to define primary and foreign keys on the physical target tables. You can use primary and foreign keys for joins.
The Define Warehouse Target Table notebook closes. The Demographics table is displayed under the Tables folder.
In this lesson, you defined a warehouse target with one target table, DEMOGRAPHICS_TARGET. In Defining data transformation and movement, you will generate target tables for this warehouse target, including the LOOKUP_MARKET dimension table for the star schema.