Chapter 10 Building Data Transformation Diagrams

Inserting a data filter

A data filter filters rows from an incoming flow using an SQL criteria.

You define criteria in the Criteria tab to specify how incoming data are filtered using source columns

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

The Criteria tab lets you define criteria expressions in an editor

To insert a data filter:

1. Select the Data Filter 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 filter to initialize it with the appropriate columns.
3. Double-click the data filter 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 criterion expression to filter by.
   
5. Click OK to save your changes and return to the diagram.

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