Getting Started Guide

10.5.3
- 10.5.5
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0

Back Next

Step 1. Create an Entity

When you create an entity, you select the driving table. Test Data Manager retrieves the related tables based on the constraints. You create an entity CUSTOMER_DATA_ENTITY that uses the CUSTOMER table as the driving table. Create a filter on the CUST_ID column in the CUSTOMER table.

Before you create an entity, identify relationships in the data and create constraints to define the child tables.

In the project, click

Define

Data Subset

Click

Actions

New

Entities

In the

New Entity

dialog box, enter the name CUSTOMER_DATA_ENTITY and optional description for the entity.

To select a driving table from the list, click

Select Table

Select the CUSTOMER table and click

The following image shows the list of tables from which you select the driving table:

The Select Driving Table obtains a list of tables with related information including owner and type.

Test Data Manager creates the entity by including all tables related to the driving table. The entity opens with a map of the relationship between the tables in the

Entity Map

tab. You can view a list of the tables on the

Tables

tab. You can view a list that shows the relationships between the tables on the

Relationships

tab.

The following image shows the entity map view of the entity CUSTOMER_DATA_ENTITY that you created:

The entity page contains a properties tab. It has separate tabs to view the entity as a map, to view the tables and view the relationships.

To create a subset of the data based on filter criteria, click

Edit

in the

Properties

pane.

Click the

Entity Criteria

tab to add criteria.

Click

Add Criteria

To filter data, select the column and table on which you want to filter data and click

The following image shows the list of columns from which you select a column to apply filter criteria:

The Add Columns dialog box contains a list of columns with the table names and related data.

You can indicate a filter condition in the entity, but define the expression in the plan.

To define the filter expression in the entity, select the operator

Greater Than

from the list to filter the data.

The following image shows the

Entity Criteria

tab where you enter the filter criteria:

Enter

100

in the value to complete the filter expression. This creates a filter for customers with customer IDs greater than 100.

For each filter criteria that you create, click

Save

. If you define multiple filters in an entity, the filter conditions are considered as "AND."

Select the row and click

Save

You can use the entity in a subset operation. Add the entity to a plan from the

Add Subset Components

page in the plan workflow.

Defining Data Subset Components

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

Getting Started Guide

Getting Started Guide

Step 1. Create an Entity

Step 1. Create an Entity