Example 3: Configuring the Output step

In the Output step, Tom 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. The columns that you defined in the Sequential File stage 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 two links, httpGET and httpPUT, and the columns that are defined on those links. In the Target column, the httpGET link is represented as a list item. Under the httpGET list item, each column is a content item.
  3. Map the target items on the httpGET link to source items:
    1. In the Target column, click the httpGET list item.
    2. In the Source column, click the top item in the list.
    3. To map the selected item and all of its child items, click Map Automatically.
  4. Map the target items on the httpPUT link to source items:
    1. In the Target column, click the httpPUT list item.
    2. In the Source column, click the top item in the list.
    3. To map the selected item and all of its child items, click Map Automatically.

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

    Each column in the httpGET and httpPUT links is mapped to a source item.
  5. Click OK to close the stage editor.