Remove Duplicates stage: Properties section
Use the Properties section on the Stage tab to specify how the Remove Duplicates stage operates.
The Properties section allows you to specify properties which determine what the stage actually does.
The following table gives a quick reference list of the properties and their attributes. A more detailed description of each property follows.
Category/Property | Values | Default | Mandatory? | Repeats? | Dependent of |
---|---|---|---|---|---|
Keys that Define Duplicates/Key | Input Column | N/A | Y | Y | N/A |
Keys that Define Duplicates/Case Sensitive | True/False | True | N | N | Key |
Keys that Define Duplicates/Sort as EBCDIC | True/False | False | N | N | Key |
Options/Duplicate to retain | First/Last | First | Y | N | N/A |