Write Range Map stage: Options section
Use the Options section on the Input tab to specify how the Write Range Map stage operates.
File update mode
This is set to Create by default. If the file you specify already exists this will cause an error. Choose Overwrite to overwrite existing files.
Range map file
Specify the file that is to hold the range map. You can browse for a file or specify a job parameter.
Key
This allows you to specify the key for the range map. Choose an input column from
the drop-down list. You can specify a composite key by specifying multiple key properties. You can
use the Column Selection dialog box to select several keys at once if
required). Key has the following dependent properties:
- Sort Order
- Choose Ascending or Descending. The default is Ascending.
- Case Sensitive
- This property is optional. Use this to specify whether each group key is case sensitive or not, this is set to True by default, that is, the values “CASE” and “case” would not be judged equivalent.
- Nulls Position
- This property is optional. By default columns containing null values appear first in the sorted data set. To override this default so that columns containing null values appear last in the sorted data set, select Last.
- Sort as EBCDIC
- To sort as in the EBCDIC character set, choose True.