Chapter 10 Building Data Transformation Diagrams

Inserting a data calculator

A data calculator lets you define basic data transformations, such as removing columns or change column order together with complex data transformations including sort, filter and aggregation.

You define criteria in the Criteria tab to specify how incoming data are transformed.

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

To insert a data calculator:

1. Select the Data Calculator 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 calculator to initialize it with the appropriate columns.
3. Double-click the data calculator symbol to open its property sheet. The Data Structure Columns tab is automatically completed with the values from the incoming flow.
4. Click the Criteria tab and type a Where expression to filter by that will apply to the incoming flows.
   
5. Click the Data Structure Columns tab and do any appropriate changes.
6. Click OK to save your changes and return to the diagram.

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