In this exercise, you will define the Tutorial Targets warehouse target, which is a logical definition for the TUTWHS database that you created in Lesson 2, Creating a warehouse database.
To define the warehouse target:
The Define Warehouse Target notebook opens.
Tutorial Targets
Warehouse for the TBC company
TUTWHS
Accept the default values for the rest of the controls on the page. For more information about the controls, see "Warehouse Target--Fields and Controls, Database page" in the online help.
The Tutorial Warehouse Group moves to the Selected warehouse groups list.
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.
Skip the Retry page. For more information about the options on the page, see "Warehouse Target--Fields and Controls, Retry page" in the online help.
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 tablespace, you can skip the Table space and Index table space fields.
Demographics data for sales regions
Demographics Target
The Data Warehouse Center will create this table when the step that loads the Demographic data is run.
You use this option when you want the Data Warehouse Center to create the target table, such as when the target table is the result of an SQL step. Clear this check box if you are using a target table that is already defined.
This check box specifies that anyone who has access to the database will have 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 Lesson 16, 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.
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 | No | City |
POPULATION | INTEGER | N/A | No | 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, so that end users of the warehouse can use the keys for joins.
The Define Warehouse Target Table notebook closes. The Demographics table is added under the Tables folder in the Selected tables list.