Sorting Output Records

In the Write to File stage, the Sort Fields tab defines fields by which to sort the output records before they are written to the output file. Sorting is optional.

  1. In Write to File, click the Sort Fields tab.
  2. Click Add.
  3. Click the drop-down arrow in the Field Name column and select the field you want to sort by. The fields available for selection depend on the fields in the dataflow.
  4. In the Order column, select Ascending or Descending.
  5. Repeat until you have added all the output fields you wish to use for sorting. Change the order of the sort by highlighting the row for the field you wish to move and clicking Up or Down.
  6. Default sort performance options for your system are set in Spectrum Management Console. If you want to override your system's default sort performance options, click Advanced. The Advanced Options dialog box contains these sort performance options:
    Note: The optimal sort performance settings depends on your server's hardware configuration. You can use this equation as a general guideline to produce good sort performance:

    (InMemoryRecordLimit × MaxNumberOfTempFiles ÷ 2) >= TotalNumberOfRecords