Chapter 10 Building Data Transformation Diagrams

Inserting a data projection

A data projection lets you define basic data transformations, such as removing columns or change column order. Data transformations such as filtering, sorting or aggregating data are not supported by data projections. You should use data calculators.

You can modify the data structure columns of a data projection.

To insert a data projection:

1. Select the Data Projection 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 projection to initialize it with the appropriate columns.
3. Double-click the data projection 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.