Use the Find and replace Clean Transformer - Define rules window to select the columns in your rules table that specify find values and their corresponding replace values that are applied when the step runs.
Restrictions:
The specification of the find value depends on the data type of the input column in your Warehouse source. The data type of the find column must match the data type of the input column.
Only numbers are allowed in numeric find columns.
Pattern strings are allowed only for character columns. Pattern strings can contain _ for any single character or % for zero or more characters. Use the rule escape character if _ or % is contained in the pattern string. For example, assume the escape character is \. To specify the character %, type \% in the find column of the rules table. For either numeric or character data, the database null value can be used as the find or replacement value.
To define the rules for the Find and Replace clean type:
Select a rules table from the Rules table list.
Select a column that contains find values. Click a column in the Available columns list, then click the > button that is next to the Find column field.
Select a column that contains replace values. Click a column in the Available columns list, the click the > button that is next to the Replace column field.
Optional: Select a column that contains the sequence in which to read rows in the rules table. Click a column in the Available columns list, the click the > button that is next to the Order by column field.
Click OK to save your changes and close the window.