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. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Glossary

Creating an Advanced Generation Rule

Creating an Advanced Generation Rule

Create an advanced generation rule to combine more than one generation technique or to generate test data in a single column or multiple columns.
  1. To access the
    Policies
    view, click
    Policies
    .
  2. Click
    Actions
    New
    Generation Rule
    .
    The
    Rule Wizard
    appears.
  3. Enter a name and an optional description for the rule.
  4. Select the advanced generation rule type.
  5. Click
    Next
    .
  6. In the
    Input Columns
    section, click
    Add New
    .
    The
    Add Column
    dialog box appears.
  7. Enter the column properties, such as the column name, data type, precision, and scale.
    You cannot enter dependencies for input columns.
  8. If you want to enter a parameter name for an input column, select
    Parameterize Input Port
    and enter the parameter name.
    When you assign a generation rule, you need not map the input column that has a parameter value.
  9. Click
    OK
    .
  10. To enter more input columns, click
    Create Port
    in the
    New generation Rule
    dialog box.
  11. In the
    Variable Columns
    section, click
    Add New
    .
  12. Enter the column properties, such as the column name, data type, precision, and scale. If you have more than one variable column, you can specify the variable dependency.
  13. Click
    OK
    .
    The variable column appears in the list of columns.
  14. To configure a rule for the variable column, click
    Configure Rule
    .
    The New Generation Rule dialog box appears.
  15. Select the generation technique. You can choose a conditional generation rule or the generation rule set.
    • Conditional. Specify conditional expressions and select the generation rules. Click
      OK
      .
    • Generation Rule Set. Specify the generation rules and the distribution percentages. You can also create a generation rule. To group the records based on the foreign keys, select Group record by foreign key. Click
      OK
      .
  16. In the
    Output Columns
    section, click
    Add New
    .
  17. Enter the column properties, such as the column name, data type, precision, and scale.
    You cannot enter dependencies for input columns.
  18. Enter an expression for the output column. Click
    OK
    .
  19. Click
    Finish
    .