Search

Tasks

Tasks

Back Next

Custom substitution masking parameters

Custom substitution masking parameters

To perform custom substitution masking, select a custom dictionary that you create.

The following table describes the parameters that you can configure for substitution masking:

Parameter	Description
Flat File Dictionary Relational Dictionary	Choose the type of custom dictionary to use.
Dictionary	Select the required dictionary from the list. You must have added the dictionary connection to the masking task. The list includes relational or flat file dictionaries depending on what you choose. For flat file dictionaries, the dictionary file must be present for all the Secure Agents in a runtime environment in the following location: <Secure Agent installation directory>\apps\Data_Integration_Server\data
Dictionary Column	The output column from the custom dictionary. For a flat file dictionary, you can select a dictionary column if the flat file contains column headers.
Order By	Applicable for relational dictionaries. The dictionary column on which you want to sort entries. Specify a sort column to generate deterministic results even if the order of entries in the dictionary changes. For example, if you move a relational dictionary and the order of entries changes, sort on the serial number column to consistently mask the data. The column that you choose must contain unique values. Do not use columns that can contain duplicate values to sort the data.
Lookup Input Port	Optional. The source input column on which you perform a lookup operation with the dictionary.
Lookup Dictionary Port	Required if you enter a lookup Input Column value. The dictionary column to compare with the input port. The source is replaced with values from the dictionary rows where the Lookup Input and Lookup Dictionary values match.
Lookup Error Constant	Optional. A constant value that you can configure when there are no matching values for the lookup condition from the dictionary. Default is an empty string.
Repeatable	Returns the same masked value when you run a task multiple times or when you generate masked values for a field that is in multiple tables.
Seed Value	A starting number to create repeatable output. Enter a number from 1 through 999. Default seed value is 190. You can enter the seed value as a parameter.
Optimize Dictionary Usage	Increases the usage of masked values from the dictionary. Available if you choose the Repeatable option. The property is not applicable if you enable unique substitution.
Is Unique	Applicable for repeatable substitution. Replaces the target column with unique dictionary values for every unique source column value. If there are more unique values in the source than in the dictionary file, the data masking operation fails. Default is nonunique substitution.
Preprocessing Expression	Configure an expression in the rule to convert characters before the masking rule runs. For example, you might want to convert all characters to the same case before masking.
Postprocessing Expression	Configure an expression in the rule to convert characters in the masked output before the data is copied to the target.

Custom substitution masking

Watch

Comments

Cloud Data Integration Homepage

0 COMMENTS

We’d like to hear from you! Log in to comment.