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. 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. Glossary

Inferred Rules

Inferred Rules

After you configure and run a column profile, TDM infers analyzes column data and infers rules based on the data. Column data types include all the inferred data types for each column in the profile results.
Column profile results contain the following types of inferred rules:
Range
The range of column values, such as the maximum and minimum lengths of values and the first and last values in each column. The range of values includes the percentage of null values in the columns. You can use rang of values for numeric and date data types.
Patterns
The patterns of data in each column and the percentage of distribution for each pattern. The sum of the distribution percentage must be equal to 100%. You can use data patterns for string and numeric data types.
List of Values
The list of unique and nonunique values in the columns and the percentage of distribution. When you assign the inferred rule type to generate test data, the sum of the distribution percentage must be equal to 100%. You can use list of values for string, numeric, and date data types.
You can assign the inferred rule type to the target columns from the
Define | Data Generation
page. Auto rules are the inferred rules that you assign after you run a column profile. When the status of inferred rule is Yes, you can assign Auto Rule to target columns to generate test data. You can edit the properties of the inferred rule types from the
Define | Data Generation
page.