Chapter 8 Building Data Transformation Diagrams

Inserting a data join

A data join performs a join on two ore more input flows, and combines them.

Steps To insert a data join:

  1. Select the Data Join tool in the palette, and create the action in the diagram.
  2. Select the Data Flow tool, and draw a flow from the preceding step (a data input or action) to the data join to initialize it with the incoming data structure columns.
  3. Double-click the data join symbol to open its property sheet, click the Join Columns tab and click the Add a Row tool to create a join.
  4. Click Column 1 and select a column to join on. Click Column 2, and select a second column to join on.
  5. Click the Join Expression column to select a join expression, and click Apply.
  6. [optional] Click the Data Structure Columns tab and delete any unnecessary columns. For example, you may want to delete one of the two columns you selected for the join.
  7. Click OK to save your changes and return to the diagram.

Note   Joins tab
You can right-click a data join symbol, and select Joins to access the Joins tab directly.

 

Copyright (C) 2008. Sybase Inc. All rights reserved.