Chapter 8 Building Data Transformation Diagrams

Inserting a data sort

A data sort sorts incoming rows by one or more data structure columns.

Steps To insert a data sort:

  1. Select the Data Sort 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 sort to initialize it with the incoming data structure columns.
  3. Double-click the data sort symbol to open its property sheet, click the Sort Columns tab and click the Select Sort Columns tool to open a selection dialog box, which allows you to select one or more columns to sort by. Make your selection, click OK to add the columns and return to the tab.
  4. For each of the sort column, click in the Order column, and specify whether it should be sorted in ascending (default) or descending order.
  5. Click OK to save your changes and return to the diagram.

Note   Sort Columns tab
You can right-click a data sort symbol, and select Sorted Columns to access the Sort Columns tab directly.

 

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