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:
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:
A list of tables displays in the right panel of the window.
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:
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.
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:
The DB2 Control Center displays a subset of the data in the table.
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.