Chapter 10 Building Data Transformation Diagrams

Inserting a data merge

A data merge allows the addition of all the rows incoming from several data flows into one outgoing data flow. Incoming flows must have identical data structure columns.

You cannot modify the data structure columns of a data merge.

To insert a data merge:

1. Select the Data Merge tool in the palette, and create the corresponding object 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 merge to initialize it with the appropriate columns.
3. Double-click the data merge symbol to open its property sheet. The Data Structure Columns tab is automatically completed with the values from the incoming flow.
4. Click the Data Structure Columns tab and do any appropriate changes.
5. Click OK to save your changes and return to the diagram.

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