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. Data Type Reference for Hadoop
  23. Glossary

Column Profile Results

Column Profile Results

After you run a column profile, you can review the results and either accept or reject the results.
To view column profile results, click the
Profile | Column Discovery
view. Review inferred pattern for all the columns. Accept or reject profiled patterns for each column. Edit the profiled pattern for columns and reject unwanted patterns or specify a pattern. Select Yes in the Inferred Rule column, select the inferred type, and save the profiled pattern.
The following image shows the column profile results:
The Column tab lists the column profiles that you can review and select for each column type. The Inferred Rule type properties are displayed in the lower pane.
The following table describes the columns in the column profile results:
Column Name
Description
Table
Name of the table.
Column
Name of the target column to apply the profile result and generate test data.
Data Type
The data type of the target column.
% Null
The number of rows that contain NULL values in the source column.
Inferred Rule
Indicates that you can apply inferred rule types to the column. Default is a hyphen. Select Yes to apply the inferred rule.
Select Inferred Type
The type of inferred rule that is applicable for the column. You can select pattern, list of values, and range based on the data type of the column.
Select a list of values or a data pattern for a string data type. Select a list of values or a range of values for a date data type.
You can select a list of values, a data pattern, or a range of values for a numeric data type.