A reference lookup generation rule is an ad hoc rule that generates data from a reference table. You can create reference lookup rules with the string, numeric, and date data types.
Create a reference lookup generation rule to generate column data using data from an existing table. Specify the parent table and assign the parent columns to child columns in the target database.
You must assign a parent table and parent column to the target column that you create the rule for. When you create the rule you can also assign parent columns from the same parent table to other target child columns.
The following image shows the reference lookup generation parameters:
Reference Lookup Generation Example
You want to generate customer identification numbers in a column. You want to use the same customer identification numbers that exist in a different table. You create a reference lookup generation rule that references the column in the other table and generates the values from that table.