Example 1: Configuring the Output step

In the Output step, John maps items in a hierarchical data structure to items in a relational data structure.

Procedure

  1. From the Assembly Editor, click the Output step. On the Output page, the output table shows the data structure that is the output of the assembly. Notice that the columns that you defined in the Sequential File stage editor are shown in the output table.
  2. Click the Mappings tab. Each item in the output structure is represented by a row in the Mappings table. You map target items to source items. For this job, the target structure has one link, httpPOST and the columns that are defined on those links. In the Target column, the httpPOST link is represented as a list item. Under the httpPOST list item, each column is a content item.
  3. Map target items of the httpPOST link to source items:
    1. In the Target column, click the httpPOST list item.
    2. In the Source column, click the top item in the list.
    3. To map the selected item and all of its descendent items, click Map Automatically.

    In the following figure, the target httpPOST list item and all of their child items are mapped to source items.

    Each column in the httpPOST link is mapped to a source item.
  4. Click OK to close the stage editor.