Business Intelligence Tutorial

Adding tables to a process

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:

  1. Click the Add Data icon:
    Figure alldata not displayed.

    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.

  2. In the Available source and target tables list, expand the Warehouse Sources tree.

    A list of the warehouse sources defined in the warehouse is displayed.

  3. Expand the tree for the Tutorial file source warehouse source.
  4. Expand the Files tree.

    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.

  5. Select the Demographics file.
  6. Click > to add the Demographics file to the Selected source and target tables list.

To add the DEMOGRAPHICS_TARGET table:

  1. In the Available source and target tables list, expand the Warehouse Targets tree.

    A list of the warehouse targets defined in the warehouse is displayed.

  2. Expand the Tutorial Targets warehouse target tree.
  3. Expand the Tables tree.

    The DEMOGRAPHICS_TARGET table is displayed in the list.

  4. Select the DEMOGRAPHICS_TARGET table.
  5. Click > to add the DEMOGRAPHICS_TARGET table to the Selected source and target tables 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:

  1. Expand the Warehouse Sources tree until you see the Tutorial Relational Source warehouse source.
  2. Expand the Tutorial Relational Source tree until you see the SAMPLTBC.GEOGRAPHIES table.
  3. Select the SAMPLTBC.GEOGRAPHIES table.
  4. Click > to add the SAMPLTBC.GEOGRAPHIES table to the Selected source and target tables list.
  5. Click OK to add the file and tables that you selected to the process.
  6. Click the demographics.txt icon and move it up until you see the DEMOGRAPHICS_TARGET table.

    The file and tables that you selected are displayed on the Process Model window.

  7. Arrange the icons in the following order from top to bottom: demographics.txt, DEMOGRAPHICS_TARGET. Leave room for one icon between demographics.txt and DEMOGRAPHICS_TARGET. Place the Geographies icon to the right of the demographics.txt icon.

Figure db2tu063 not displayed.

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.


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