Table of Contents

Search

  1. Preface
  2. Introduction to TDM Administration
  3. User and Role Administration
  4. Security Administration
  5. System Preferences
  6. TDM Server Administration
  7. Connections
  8. Dictionaries
  9. User-Defined Datatypes

Flat File Dictionaries

Flat File Dictionaries

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:
SNO,GENDER,FIRSTNAME 1,M,Adam 2,M,Adeel 3,M,Adil 4,F,Alice 5,F,Alison
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.
You cannot use flat file dictionaries when you want to mask Hadoop data.