The Assign number masking activity allows you to assign an integer value to a specified column of all table records.
|Table of contents|
To use the Assign number masking activity, it must be placed inside a table masking activity or a similar activity that iterates over data. Once placed, select the property you want to mask and enter the integer value you want to assign to that property.
While you can directly set a desired value, you can also use custom code to generate a value with a custom algorithm and data. Note that the Assign number masking activity remembers the first value it assigns to a record and assigns the same values to others, i.e. the value (or the custom code that determines the value) is evaluated only once. If you want to dynamically change the assigned value based on available data during package execution, use the Evaluate numeric function masking activity instead.
In this example we want to mask the CSC (Credit Card Security) number in the CreditCard table. We don't need realistic values from this column during testing, but we still need to mask sensitive data and want to use a valid value. The best way to do this is by assigning an arbitrary integer (e.g. 0) to every record in this table. First we place the CreditCard masking activity and put the Assign number masking activity within it. Once placed, we select the Csc property that we want to mask with our chosen integers. Here, we will put
0 as the value we want to assign. We leave other properties as they are.
Figure 1: Assigning numbers
|Property group||Property name||Description||Example|
|Input properties||DataItemProperty||The property to mask.||Write
|Value||The value to use as a replacement value.||
|Input: Filter||Filter||Expression used for filtering records - only filtered items will be masked.||
|SkipDefaultValues||If true, default values will be omitted in masking (i.e. null values are not masked).||
|Input: Repeating||RepeaterId||The ID of the repeater that will be used to detect repeating and save results when masking item key repeats.||
|RepeatingKey||Key to use for repeating detection.||Write
|Misc||DisplayName||Display name of the activity in the workflow.||
|Result||Contains the masking definition object. It's a part of the masking infrastructure and should be ignored.||-|