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

Data Coverage Analysis

Data Coverage Analysis

You create a data coverage task and plot the regions on the X axis and the paygrade column on the Y axis.
The data that you plot creates the following data on the graph:
Region/Paygrade
Low
Medium
High
East
0
1
0
West
0
0
0
North
0
1
0
South
2
1
0
There is more than one record in the cell that represents low paygrade in the south. The test cases that you run do not require data for low paygrades. You want to move data to the cells that represent high paygrade in the west and medium paygrade in the east.
You run a Fill Cell job to fill data in the cell that represents medium paygrade in the east. Choose to move one record from the cell that represents low paygrades in the south.
To perform this Move operation, the EMP_INFO table is updated. One record that has a Branch ID that represents the south and a low paygrade is edited. The move updates the paygrade to Medium and the BRANCH_ID to 103. No user input is needed as all the other data required is available.
You run a Fill Cell job to fill data in the cell that represents high paygrade in the west. Choose to move one record from the cell that represents low paygrades in the south.
To perform this Move operation, the EMP_INFO table must be updated. The operation must add a record that contains a branch ID for the west. The branch ID in the EMP_INFO table is a foreign key that points to the BRANCH_DATA table. The BRANCH_DATA table does not contain a record for the west region. A record for the west region must be added to the BRANCH_DATA table. The operation adds a record to the BRANCH_DATA table and populates the region ID as 2 for West. The BRANCH_ID information and other information cannot be populated and must be manually entered.
A user input dialog box appears with fields to enter values for the following columns:
  • BRANCH_ID
  • BRANCH_NAME
  • IFSC
  • FACILITY
Therefore this Move operation updates two tables. A row is added to the BRANCH_INFO table. Data is modified in the EMP_INFO table.