Associating each input item with a column of the database table

About this task

To associate each input item with a column of the database table:

Procedure

  1. Click the col1 icon and hold the mouse button down.
    A box appears around the icon and its name.
  2. Drag the boxed icon to the input3 icon in the right pane.
  3. Release the mouse button.
    The associated items appear in the second column of each pane. The following figure shows the Map-Definition window with this step completed.
    Figure 1: The Map-Definition window with one association completed

    begin figure description - This figure is described in the surrounding text. - end figure description

  4. Connect col2 to input2.
  5. Connect col3 to input1.
    The following figure shows the window with all three connections completed.
    Figure 2: The Map-Definition window with all associations completed

    begin figure description - This figure is described in the surrounding text. - end figure description

  6. Click OK to return to the Map Views window.
  7. Click Cancel to return to the Load Job window.

Results

The Load Job window now has entries in all of the required areas, as the following figure shows. The ipload utility was able to enter the table name and the target database name (upper right area) because you specified the database and table as you built the map.
Figure 3: The Load Job window with all required component boxes completed

begin figure description - This figure is described in the surrounding text. - end figure description

You have finished all of the required parts of the Load Job window, but you might want to modify the options, as discussed in the next section.