You can configure Data Masking transformation runtime properties to increase performance.
Configure the following runtime properties:
Cache Size
The size of the dictionary cache in main memory. Increase the memory size in order to improve performance. Minimum recommended size is 32 MB for 100,000 records. Default is 8 MB.
Cache Directory
The location of the dictionary cache. You must have write permissions for the directory. Default is CacheDir.
Shared Storage Table
Enables sharing of the storage table between Data Masking transformation instances. Enable Shared Storage Table when two Data Masking transformation instances use the same dictionary column for the database connection, seed value, and locale. You can also enable the shared storage table when two ports in the same Data Masking transformation use the same dictionary column for the connection, seed, and locale. Disable the shared storage table when Data Masking transformations or ports do not share the dictionary column. Default is disabled.
Storage Commit Interval
The number of rows to commit at a time to the storage table. Increase the value to increase performance. Configure the commit interval when you do not configure the shared storage table. Default is 100,000.
Encrypt Storage
Encrypts storage tables, such as IDM_SUBSTITUTION_STORAGE and IDM_EXPRESSION_STORAGE. Verify that you have encrypted data in storage tables before you enable the encrypt storage property. Clear this option if you do not want to encrypt the storage tables. Default is disabled.
Storage Encryption Key
The Data Masking transformation encrypts the storage based on the storage encryption key. Use the same encryption key for each session run of the same Data Masking transformation instance.
Substitution Dictionary Owner Name
Name of the substitution dictionary table owner when you select the substitution masking type. If the database user specified in the database connection is not the owner of the substitution dictionary table in a session, you need to specify the table owner.
Storage Owner Name
Name of the table owner for IDM_SUBSTITUTION_STORAGE or IDM_EXPRESSION_STORAGE when you select repeatable expression or unique repeatable substitution masking type.