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. Data Sets
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Data Type Reference for Hadoop
  22. Glossary

Data Generation Rule Types

Data Generation Rule Types

A data generation rule is a rule that defines how you want to generate data in the target table. When you create a data generation rule, you choose a generation technique and configure generation parameters.
You can create the following data generation rule types:
Standard
A data generation rule that uses predefined generation techniques.
Custom
A data generation rule that generates data based on PowerCenter mapplets logic.
Ad Hoc
A data generation rule that you create within a project for a column in the target table.
Standard rules and custom rules are global rules. Global rules are rules that you create in the
Policies
view of Test Data Manager. When you create a global generation rule in the
Policies
view, you specify a rule name. This rule is available for projects that you create. You assign the rule to one or more columns in the project that you want to generate data into.
Ad hoc generation rules are rules that you create in the
Define | Data Generation
view of a project. Ad hoc rules do not have a name, and you cannot move an ad hoc rule. You can create ad hoc generation rules within the projects. You select the target columns for an ad hoc generation rule when you create the rule. You can select a standard generation technique for an ad hoc generation rule or you can select an ad hoc generation technique. You can use reference lookup, effective dates, and expression generation techniques only in an ad hoc generation rule. In an ad hoc rule, if you want to generate numbers in a column that uses string data type, you can change the data type to numeric.
After you install TDM and log in to Test Data Manager, TDM configures the default generation rules that comes with the installation package.
A data generation technique defines the logic that generates the data. When you create a generation rule, the techniques vary based on datatype you select. Generation parameters are options that you configure for a generation technique. For example, you can define different start dates and end dates for random date generation.
You can enable users to override generation parameters for a rule. For example, you create a rule that generates random dates from 2011 to 2012. You set the override option for the rule. When a user assign this rule to a target column, the user can select Saturday and Sunday as exclude dates so that the rule generates random weekday dates from 2011 to 2012.