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. 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

Reference Lookup Generation Parameters

Reference Lookup Generation Parameters

Create reference lookup rules for string, numeric, and date data types.
The following table describes the parameters that you can configure to generate data from a reference lookup table:
Parameter
Description
Minimum Value
The minimum number of child records for a parent record. Default is 1.
Maximum Value
The maximum number of child records for a parent record. Default is 3.
Data Source
The connection to the parent table.
Parent Table
The parent table that you can get the data from.
Child Column
The column name on which you create the rule. You cannot remove the first child column. To enter additional child columns, you can add more rows.
Parent Column
The parent column for the corresponding child column. You add more rows to enter additional child and parent columns. You can also assign parent columns from the same parent table to the other target child columns.
Parent Table Filter
A conditional expression that you enter to extract the data. The data you extract from the parent table must conform to this condition.
Parent records without children
The percent of parent records without a child.
Child records without a parent
The percent of child records without a parent. You can enter a value greater than 0. If you enter 0, you must provide a default value instead of null values.
Default Value
The default value that you want to generate in the target column instead of null values. The default value can be one of the values present in the parent table if the tables are in a parent-child relationship. Required if the percent of child records without a parent is set to 0. Optional if the percent of child records without a parent field is blank. Disabled if you enter a non-zero value in the percent of child records without parent field to generate null values.