Merge stage: Merge keys section
Use the Merge Keys section on the Stage tab to specify how the Merge stage operates. Click Edit in the Merge Keys section to update the key properties.
Key
This specifies the key column you are merging on. Repeat the property to specify multiple keys. 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
Use this to specify whether each merge 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.
- Sort as EBCDIC
To sort as in the EBCDIC character set, choose True.
- Nulls position
By default columns containing null values appear first in the merged data set. To override this default so that columns containing null values appear last in the merged data set, select Last.