Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. Glossary

Creating an Entity

Creating an Entity

You can create an entity with tables in a data set. When you create an entity, you select the driving table. Test Data Manager retrieves the related tables in the data set based on the constraints. You can add filter criteria to the driving table to filter source data when you create the subset of the data set. You can disable relationships between tables in the entity.
  1. Open the required data set.
  2. Click
    Related Data Sets
    and open the
    Subset Components
    tab.
  3. Click
    Actions
    New
    Entities
    .
  4. In the
    New Entity
    dialog box, enter a name and optional description for the entity.
  5. Click
    Select Table
    to select a driving table from the list.
  6. Click
    Save
    .
    Test Data Manager adds the related tables to create the entity and 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.
  7. To create a subset of the data based on filter criteria, click
    Edit
    in the
    Properties
    pane.
    The
    Edit Criteria
    dialog box appears.
  8. To add criteria for a column, click the
    Entity Criteria
    tab.
  9. Click the
    Add Criteria
    button.
  10. Select the columns on which you want to filter data and click
    OK
    .
    The columns that you select appear in the columns list in the
    Entity Criteria
    tab.
  11. If you want to define the filter expression in the entity, select an operator from the list to filter the data.
    You can indicate a filter condition in the entity, but define the expression in the plan.
  12. If you enter a filter condition, enter a specific value or a variable to complete the filter expression.
    If you want to provide a variable in the entity criteria, you must start the parameter value with "$$".
  13. Click
    Save
    for each filter criteria that you create. If you define multiple filters in an entity, the subset operation includes data that meets all filter criteria.
  14. Click
    OK
    to exit the
    Edit Criteria
    dialog box.