Chapter 8 Building Data Transformation Diagrams

Inserting a data projection

A data projection performs basic data transformations, such as removing columns or changing the order of columns. For more advanced transformations, see Inserting a data calculator.

To insert a data projection:

1. Select the Data Projection 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 projection to initialize it with the incoming data structure columns.
3. Double-click the data projection symbol to open its property sheet, and click the Data Structure Columns tab, which is automatically completed with the values from the input flow. Reorder or delete columns as appropriate.
4. Click OK to save your changes and return to the diagram.

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