Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  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. Appendix A: Data Type Reference
  21. Appendix B: Data Type Reference for Test Data Warehouse
  22. Appendix C: Data Type Reference for Hadoop
  23. Appendix D: Glossary

Creating an Entity

Creating an Entity

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.
  1. Open a project.
  2. Click
    Define
    Data Subset
    .
  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 and click
    OK
    .
  6. Click
    Save
    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.
  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 selected appear in the columns list in the
    Entity Criteria
    tab.
  11. To define the filter expression in the entity, select the attribute from the Attribute list. Choose
    Value
    to enter a value or
    Parameter
    to enter a parameter.
    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.
  12. Select an operator from the list to filter the data.
  13. If you enter a filter condition, enter a specific value or choose the parameter from the list of parameters to complete the filter expression. The list of parameters includes project and global parameters. Global parameters are indicated with an asterisk (*).
  14. Click
    Save
    for each filter criteria that you create. If you define multiple filters in an entity, the filter conditions act as "AND."
  15. Click
    Save
    to exit the
    Edit Criteria
    dialog box.

0 COMMENTS

We’d like to hear from you!