Example 2: 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 one link, httpDELETE, and the columns that are defined on that link. In the Target column, the httpDELETE link is represented as a list item. Under the httpDELETE list item, each column is a content item.
  3. Map target items on the httpDELETE link to source items:
    1. In the Target column, click the httpDELETE 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 httpDELETE list item and all of its child items are automatically mapped to source items.

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