To define the flow of data, you need to add each source that the steps transform and the target tables that result from the transformation.
In the Build Tutorial Market Dimension process, you will load the Demographics file into the target database. The source file and the DEMOGRAPHICS_TARGET table for the step have to be added to the process. The Demographics source file is part of the Tutorial File Source warehouse source, which you defined in Lesson 6, Defining warehouse sources. The DEMOGRAPHICS_TARGET table is part of the Tutorial Targets warehouse target, which you defined in Lesson 7, Defining warehouse targets.
To add the Demographics file:
Click the canvas (the area on the right side of the window) at the spot that you want to place the table. The Add Data window opens.
A list of the warehouse sources defined in the warehouse is displayed.
In the tree, you should see
X:\program files\sqllib\samples\db2sampl\dwc\demographics.txt, where X is the drive on which you installed the sample.
To add the DEMOGRAPHICS_TARGET table:
A list of the warehouse targets defined in the warehouse is displayed.
The DEMOGRAPHICS_TARGET table is displayed in the list.
In the next part of this exercise, you need to add the source table. When you define a step that selects data from the SAMPLTBC.GEOGRAPHIES table, you can specify that the Data Warehouse Center automatically generate a target table, so you do not need to add a target table.
To add the SAMPLTBC.GEOGRAPHIES source table:
The file and tables that you selected are displayed on the Process Model window.
The last step will use the Demographics table and the SAMPLTBC.GEOGRAPHIES table as sources, so you do not need to specify sources for the step. You can specify that the Data Warehouse Center automatically generate the resulting target table, LOOKUP_MARKET, so you do not need to specify a target table for the step.