Table of Contents

Search

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

Dictionary Generation

Dictionary Generation

A dictionary generation rule is a global or ad hoc generation rule that loads dictionary values into the target test database.
Before you create a dictionary generation rule, you must add a dictionary to TDM in the
Administrator | Dictionaries
view. Users that have permissions to create generation rules have permissions to add dictionaries.
Dictionary generation can use the string, numeric, date, and binary data types. You can create a rule based on a dictionary column. The binary data type contains a serial number column that increases performance. Generate dictionary values for columns that have a finite number of values, such as states or countries.
You can create dictionary generation rule either from a flat file or relational database. You can generate data for a binary data type from relational databases but not from flat files.
Dictionary generation rules can be global rules or ad hoc rules.
The following image shows the dictionary generation parameters:
The dictionary generation parameters are dictionary name, dictionary column, generate unique values, null values, and invalid values.

Dictionary Generation Example

You want to load customer names into the target database. You import a dictionary that has first and last name columns. You create two dictionary rules with the string data type. When you create the first name rule, you select the dictionary that contains the names and choose the first name dictionary column. In the last name rule, you select the same dictionary and choose the last name dictionary column.