Business Intelligence Tutorial

Defining a warehouse target

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:

  1. From the Data Warehouse Center window, right-click the Warehouse Targets folder.
  2. Click Define.

    The Define Warehouse Target notebook opens.

  3. In the Name field, type the business name for the warehouse target:
     Tutorial Targets
    
  4. In the Administrator field, type your name as the contact for the warehouse target.
  5. In the Description field, type a short description of the data:
    Warehouse for the TBC company
    
  6. In the Warehouse target type list, select DB2 UDB for your operating system.
  7. Click the Database tab.
  8. In the Database name field, select the name of the database:
    TUTWHS
    
  9. In the User ID field, type the user ID for the Default DWC User.
  10. In the Password field, type the password for the user ID.
  11. In the Verify password field, type the password again.

    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.

  12. Click the Security tab.
  13. Select the Tutorial Warehouse Group.
  14. Click >.

    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.

  15. Click OK to save your changes and close the Define Warehouse Target notebook.
  16. Expand the Warehouse Targets tree until you see the Tables folder under the Tutorial Targets warehouse target.
  17. Right-click the Tables folder and click Define.

    The Define Warehouse Target Table notebook opens, and you can define the DEMOGRAPHICS_TARGET table.
    Figure db2tu023 not displayed.

  18. In the Table schema field, select the user ID under which you created the warehouse database in Lesson 2, Creating a warehouse database.
  19. In the Table name field, type the name of the 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.

  20. In the Description field, type the description of the table:
    Demographics data for sales regions
    
  21. In the Business name field, type the Business name (a descriptive name that users will understand) for the table:
    Demographics Target
    
  22. Verify that the Data Warehouse Center created table check box is selected.

    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.

  23. Verify that the Grant to public check box is selected.

    This check box specifies that anyone who has access to the database will have access to the table.

  24. Clear the Part of an OLAP schema check box.

    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.

  25. Click the Columns tab.
  26. Right-click the empty space in the list.
  27. Click Add.

    A row is added to the list, and you can define the State column, which is one of the main values for the table.

  28. Click the Column name column, and type STATE.
  29. In the Data type column, verify that CHAR is selected.
  30. Click the Length column and type 50.

    Skip the Precision and Scale columns because they apply to decimal data only.

  31. Verify that the Nullable check box is selected.
  32. In the Business name field, type State.
  33. Repeat steps 26 through 32 to define the rest of the columns in the table:
    Name Data type Length Allow nulls Business name
    CITY CHAR 50 No City
    POPULATION INTEGER N/A No Population

    The Columns page of the Define Warehouse Target Table notebook

    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.

  34. Click OK.

    The Define Warehouse Target Table notebook closes. The Demographics table is added under the Tables folder in the Selected tables list.


[ Top of Page | Previous Page | Next Page | Table of Contents ]