You can use a mapping parameter to define a seed value. Create a mapping parameter for each seed value that you want to add to the transformation. The mapping parameter value is a number between 1 and 1,000.

When you configure data masking for a column, select Mapping Parameter for the seed. The Designer displays a list of the mapping parameters. Select a mapping parameter from the list. Before you run a session, you can change the mapping parameter value in a parameter file for the session.

Create the mapping parameters before you create the Data Masking transformation. If you choose to parametrize the seed value and the mapping has no mapping parameters, an error appears. If you select a port with a masking rule that references a deleted mapping parameter, the Designer generates a new random seed value for the port. The seed value is not a mapping parameter. A message appears that the mapping parameter is deleted and the Designer creates a new seed value.

The Integration Service applies a default seed value in the following circumstances:

The Integration Service applies masked values from the default value file. You can edit the default value file to change the default values.

The name-value pair for the seed is

If the seed value in the default value file is not between 1 and 1,000, the Integration Service assigns a value of 725 to the seed and writes a message in the session log.