Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Data Sets
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Data Type Reference for Hadoop
  22. Glossary

Dictionary Connections

Dictionary Connections

A dictionary is a flat file or relational table that contains substitute data. When you define a relational dictionary, you can define the connection to the dictionary in the project plan and workflow.
The
Dictionary Connection
field appears in the
Plan Settings
if the plan requires a connection.
When you define a substitution masking rule with a flat file dictionary, you can browse to a dictionary from Test Data Manager. Test Data Manager imports the structure of the dictionary file to enable you to define the serial number column and the lookup column.
By default, when you run a workflow, the PowerCenter Integration Service finds flat file dictionaries in the following location:
<Informatica installation directory>\server\infa_shared\lkpfiles
You cannot change this location. The TDM installation installs the built-in dictionaries in the lkpfiles location. When you create a custom dictionary file, Test Data Manager copies the file to the
lkpfiles
directory.
To access a dictionary on Microsoft SQL Server, create an ODBC connection using the DataDirect SQL Server Wire Protocol driver.