An ad hoc generation rule is a data generation rule that you create within a project. You can create an ad hoc generation rule for a column in the target table.
An ad hoc rule does not have a name. You cannot move an ad hoc rule because you use target columns to define the rule.
An ad hoc generation rule includes the standard data generation techniques and the techniques such as reference lookup generation, effective dates generation, and expression generation. An ad hoc rule can have more than one target column, based on the generation technique that you select.
When you create an ad hoc rule, the generation techniques that you can select depend on the data type of the column. To create an ad hoc rule, you can use a standard or an ad hoc generation technique. The ad hoc generation techniques include expression generation, reference lookup generation, and effective dates generation.
For example, an Airport table contains airport codes. You create a reference lookup rule on a From_City column that generates data from the Airport table and inserts it into the From_City column in the target table.
In an ad hoc rule, if you want to generate numbers in a column that uses string data type, you can change the data type to numeric. For example, Employee_ID is a sequence of numbers and the target table contains the Employee_ID column with string data type. To generate numbers in the column, select