Remove Duplicates stage: Keys that define duplicates section
Use the keys that define duplicate section on the Stage tab to specify how the Remove Duplicates stage operates.
Key
Specifies the key column for the operation. This property can be repeated to specify multiple key columns. You can use the Column Selection dialog box to select several keys at once if required. Key has dependent properties as follows:
- Case Sensitive
Use this to specify whether each 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.