DataFlux Data Management Studio 2.5: User Guide

Transformation Scheme Node

The Transformation Scheme Node transforms the input by table lookup. For example, to standardize variant spellings to a common form.

Used in:

• Match Definitions
• Standardization Definitions

Properties

Scheme

Select a scheme to use. Click Edit to edit the selected scheme in the Scheme Editor.

Apply scheme

Select one of the option buttons to apply the scheme to all substrings of the input, or to the input as a whole.

Case sensitive scheme lookup

Select this check box if the input case must match the case of the entry in the scheme in order to be transformed.

Output case

Select the case of the node output. Selecting (None) leaves the case unchanged.

Output

Message

If the scheme matches the input, "Changes were applied". Otherwise, the message will be, "No changes were applied".

Result

The input after transformation.

Note: The result may be the same as the input even though "Changes were applied" appears in the message, if the scheme transforms the input to itself.