A flat file dictionary is a file that contains dictionary information. You can use a flat file dictionary with email address and substitution masking. You can use a flat file dictionary to generate data for string, numeric, and date datatypes.
TDM installs with sample dictionary files that you can use for names and addresses. You can find the dictionary files in the following location:
<TDM installation directory>/TDM/infa_shared/LkpFiles
When you use a dictionary file in a masking or a generation rule, the Test Data Manager imports the structure of the dictionary file and stores the column names.
The following text shows a sample flat file dictionary that contains first name and gender:
In this dictionary, the first field in the row is the serial number, and the second field is gender. The PowerCenter Integration Service looks up a dictionary record by serial number. You can add gender as a lookup condition. The PowerCenter Integration Service retrieves a row from the dictionary using a hash key, and it finds a row with a gender that matches the gender in the source data.