Assigning Test Data Profiles to Columns

You can associate a test data profile directly to a column or to a domain.

Note: To assign a test data profile to a domain (see Domains (CDM/LDM/PDM), open the domain property sheet and select the appropriate test data profile in the Profile list on the General tab. A test data profile assigned to a domain will generate test data for all the columns attached to the domain.

Open the property sheet of a column and click the Detail tab.
Select the appropriate test data profile.
[optional] Adjust the following properties in the Column fill parameters group box as appropriate:
- Null values - [Default: 0%] Specifies the percentage of values to leave empty.
- Distinct values - [Default: 100%] Specifies the percentage of values that must be unique. This is a maximum value, and can change depending on the referential integrity parameters of primary key columns. Alternately, you can enter a specific value without a percentage sign, to indicate the exact number of column rows that should contain unique entries.
- Average Length - [read only] Used for estimating the size of the database (see Estimating Database Size). The default value is the maximum length for the data type defined for the column.
Note: These properties on the column property sheet General may override values entered in the Column fill parameters groupbox:
- Mandatory (M) - Specifies that the column must contain a value and sets Null values to 0%.
- Unique (U) - Specifies the column must contain a unique value and sets Null value to 0% and Distinct values to 100%.
- Foreign (F) - The column is a foreign key column and takes the values of the corresponding primary key column in the parent table.
Click OK to close the column property sheet and return to the model.

Note: To quickly assign test data profiles to multiple columns, use the List of Columns or the Columns tab of a table property sheet. If the Test Data Profile column is not visible in your list, use the Customize Columns and Filter tool to display it.