A dictionary is a flat file or relational table that contains substitute data and a serial number. You can use a dictionary to replace sensitive data in a table. You can use data from a dictionary to generate data.
Add a dictionary in the
Administrator | Dictionaries
view that you want to use in data masking or data generation rules. When you create a masking rule, you can define the dictionary that you want to use to mask sensitive data. Before you create a data generation rule, you must add dictionary to TDM.
The
PowerCenter Integration Service
generates a number and retrieves a dictionary row based on the serial number from the dictionary. It generates a hash key for repeatable masking or a random number for non-repeatable masking. You can configure an additional lookup condition if you configure repeatable masking.
You can create a generation rule to load the dictionary into target databases. The binary data type contains a serial number column that increases performance. You can configure serial number for relational databases when you create a data generation rule for binary data type.