DataFlux Data Management Studio 2.7: User Guide

Transformation Scheme Node

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

Used in:

• Match Definitions
• Standardization Definitions

Properties for Match Definitions

Scheme:

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

Scheme lookup is case sensitive

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

Do not use phonetic analysis if transformation occurs

Select this checkbox to disable phonetic analysis after transformation. You might want to do disable phonetic analysis if you want the standard from your scheme to appear in the matchcode without any additional transformations applied during phonetic processing. You might choose this option if your scheme contains a comprehensive set of values and you are confident that you can achieve the desired level of matching without using phonetic reduction on the token to containing this node.

Sensitivity range:

Select the upper and lower sensitivity range in which this scheme will be applied.

Scheme lookup is based on:

Select Substring to apply the scheme to all substrings of the input. Select Full Phrase to apply the scheme to the input as a whole.

Properties for Standardization Definitions

Scheme:

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

Output case:

Use this control to select the case of the node output. Selecting (None) leaves the case unchanged.

Scheme lookup is case sensitive

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

Scheme lookup is based on:

Select Substring to apply the scheme to all substrings of the input. Select Full Phrase to apply the scheme to the input as a whole.

Output

Message

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

Result

The input after transformation.

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