Chapter 8 Building Data Transformation Diagrams

Inserting a data filter

A data filter filters incoming rows using SQL criteria.

Steps To insert a data filter:

  1. Select the Data Filter 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 filter to initialize it with the incoming data structure columns.
  3. Double-click the data filter symbol to open its property sheet, click the Criteria tab, and enter a criterion expression to filter by.
  4. Click OK to save your changes and return to the diagram.

Note   Criteria tab
You can right-click a data filter symbol, and select Criteria to access the Criteria tab directly.

 

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