To perform expression masking or substitution masking with repeatable values, you must assign a storage table for the repeatable values. You can create the table in the TDM repository database or in another database. Test Data Management creates a default storage connection and creates storage tables for this connection.
If you choose to use a different storage connection, you must set this connection as the default connection and create the storage tables for the connection. Set the connection as the default storage and staging connections and create storage tables in Test Data Manager.
Staging connections and storage connections can be on Oracle, Sybase, IBM DB2, PostgreSQL, or Microsoft SQL Server databases. You can create a staging connection on Teradata and Teradata Parallel Transporter connections.
You can create the storage tables for the required staging and storage connection from the
view in Test Data Manager.
You can also use the SQL scripts that Informatica provides to create the storage tables. Use your database client tool to run the SQL script and create the table in the database. For example, you can use the SQL*Plus client for Oracle to create the storage table in an Oracle database.
Run the storage table SQL script for your database. For example, to create the substitution storage table in a Microsoft SQL Server database, run the
file. The SQL scripts to create the storage table for repeatable expression masking are installed in the following TDM directory:
<Informatica installation directory>/TDM/storage_script/expression_storage
After you run the expression storage script, verify that the script created the IDM_EXPRESSION_STORAGE table in the database. The SQL scripts to create the storage table for repeatable substitution masking are installed in the following TDM directory:
<Informatica installation directory>/TDM/storage_script/substitution_storage
After you run the substitution storage script, verify that the script created the IDM_SUBSTITUTION_STORAGE table in the database.
The expression and substitution storage tables can contain original values from the source database and the corresponding masked values from the target database. Ensure that access to the storage table is secure. Alternatively, you can create the expression or substitution storage table in a database with limited user access.