Benefits and capabilities

We have seen different types of format entries that can be used when creating the masking format. The examples we used were Random Numbers, Encrypt (key-based reversible masking), Table Column, Array List, Random Digits, and Random Strings. Another format entry is Shuffle, which is used to randomly shuffle the values in a column across different rows. You can use this when the format of the column is unknown, making it impossible to generate realistic values. A user-defined function can also be used as the format entry to generate the masked value, for example, if an algorithm is required to derive a value such as an account number.

Alternatively, use Substitute as the format entry for deterministic masking. A table and column need to be specified, and the values in the specified column will be selected using a hash value to deterministically mask the original column. This can be used to mask a similar original column in the same way, in multiple tables and even...