Business Intelligence Tutorial

Testing the Load Demographics Data step

In this exercise, you will promote and run the Load Demographics Data step. Then you will promote the rest of the steps in the Build Tutorial Market Dimension process.

To promote the Load Demographics Data step:

  1. From the Process Model window for the Build Tutorial Market Dimension process, right-click the Load Demographics Data step.
  2. Click Mode-> Test.

    The Data Warehouse Center starts to create the target table, and displays a progress window. Wait until the Data Warehouse Center finishes processing before you start the next procedure.

    A lock appears on the step icon to indicate that only non-destructive changes can be made to the step.

To verify that the Demographics target table was created:

  1. If the Control Center is not open, then from the main Data Warehouse Center window, click Tools -> Control Center to open the DB2 Control Center.
  2. Expand the object tree until you see TUTWHS, the warehouse database that you created in Lesson 2, Creating a warehouse database.
  3. Expand the TUTWHS database tree.
  4. Click the Tables folder.

    A list of tables displays in the right panel of the window.

  5. Verify that the DEMOGRAPHICS_TARGET table is there.

    If you are looking in the Control Center, right-click the Tables folder and click Refresh to refresh the list of tables in the right panel.

To test the Load Demographics Data step:

  1. From the Process Model window for the Build Tutorial Market Dimension, right-click the Load Demographics Data step.
  2. Click Test.
  3. From the main Data Warehouse Center window, click Warehouse-->Work in Progress.

    The Work in Progress window opens. You use the Work in Progress window to monitor the progress of all steps in the Data Warehouse Center that are running or scheduled. You should see an entry for the step that is running. While the step is running, it has a status of Populating. When it finishes running, it should have a status of Successful.


    The GEOGRAPHIES SELECT statement on the SQL Statement page.

    For more information about the Work in Progress window, see "Work in Progress--Overview" in the online help.

To verify the results of the step's processing:

  1. From the DB2 Control Center, right-click the DEMOGRAPHICS_TARGET table.
  2. Click Sample Contents.

    The DB2 Control Center displays a subset of the data in the table.

  3. Click Close.

Repeat the steps in this lesson for the Select Geographies Data step and the Join Market Data step. The target table for the Select Geographies Data step is GEOGRAPHIES_TARGET. The target table for the Join Market Data step is LOOKUP_MARKET.


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