When you create an entity, you select the driving table. Test Data Manager retrieves the related tables based on the constraints. You can add filter criteria to the driving table to filter source data when you create the data subset database. You can disable relationships between tables in the entity.
To use parameters in an entity, you must create the entities in the project before you create the entity. Before you create an entity, perform data discovery to identify constraints. Add constraints to the source to define the child tables.
Open a project.
dialog box, enter a name and optional description for the entity.
to select a driving table from the list and click
to create the entity.
Test Data Manager displays a diagram of the relationship between the tables in the entity. You can view a list of the tables or a list that shows the relationships between the tables.
To create a subset of the data based on filter criteria, click
dialog box appears.
To add criteria for a column, click the
Select the columns on which you want to filter data and click
The columns that you selected appear in the columns list in the
To define the filter expression in the entity, select the attribute from the Attribute list. Choose
to enter a value or
to enter a parameter name.
You can indicate a filter condition in the entity, but define the expression in the plan. You can choose to create multiple criteria with parameters and include required parameters when you run a workflow.
Select an operator from the list to filter the data.
If you enter a filter condition, enter a specific value or choose the variable from the list of variables to complete the filter expression.
for each filter criteria that you create. If you define multiple filters in an entity, the filter conditions act as "AND."