Set of Values Generation
A set of values generation rule is a global or ad hoc rule that writes a small data set to the target table. You can list the data values that you want to write to the table when you create a set of values generation rule.
You can use the string, numeric, and date data types in a set of values generation rule. You add data values in the rule and specify what percent of the rows in the target table you want to have the value. You can enter the percent in decimal values. You can use set of values generation for columns that have a small number of values, such as membership status.
Set of values rules can be global rules or ad hoc rules.
The following image shows the set of values parameters:
Set of Values Generation Example
You want to generate payment information. The target database has a PAYMENT_TYPE column with Visa, MasterCard, and Paypal values. You want 60% of the rows to have the Visa value, 30% of the rows to have the MasterCard value, and 10% of the rows to have the Paypal value.
You create a set of values rule with the string data type. You add Visa in the value field and enter 60 in the distribution percent field. You click the add button twice to add two additional values to the rule. In the second row, you enter MasterCard in the value field and 30 in the distribution percent field. In the third row, you enter Paypal in the value field and 10 in the distribution field.
Set of Values Generation Parameters
Configure set of values parameters to generate data for string, date, and numeric data types.
The following table describes the parameters that you can configure to generate a set of values:
Parameter | Description |
|---|
Value | The exact data value that you want to write to a target table. You can enter exact values for the string and numeric data types. You enter a date for date data type. If you want to use more than one value, you can add more rows. |
Distribution% | The percent of rows for the specified value. The sum of the distribution of the values have to be 100%. You can enter a decimal value in the distribution percent field. |
Null Values | A list of global rules or default rule that are available for the data type you select. A null value is a value that a default rule or a global rule generates in the target columns based on the data type you select. |
Invalid Values | A list of global rules or default rule that are available for the data type you select. Any number, date, or string that is not a part of the set of values is not valid. |
