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

Creating a Data Coverage Column Using Mappings

Creating a Data Coverage Column Using Mappings

Create a column using mappings to analyze the data coverage of data values across specific groups of data values.
Review the list of data type exceptions before you create a data coverage column.
  1. Open the data coverage page.
  2. To add a column that you want to plot on the graph, click the
    Add
    button on the
    Columns
    pane.
    The
    Add Column
    window opens.
  3. From the list of tables, select the table that contains the column.
  4. From the list of columns, select the source data column to which this column refers.
    The column data appears in the
    Data Preview
    pane.
  5. Enter an alias name for the column.
    Column aliases must be unique within a task.
  6. Select the
    Mapping
    type.
    The data from the preview tab is added to the Values tab.
  7. Optional. You can edit the data in the
    Values
    tab. Click the
    Edit
    button to edit the values. Click the
    Reset
    button to replace the edited data with data from the preview pane.
  8. To create a mapping value, click the
    Edit
    button in the mapping values panel.
  9. In the
    Value
    field, enter a mapping value name and click the
    Add
    button to create another value field.
  10. Repeat step 9 to create the required number of mapping values.
  11. Click
    OK
    .
  12. In the
    Add Column
    window, select a data value in the Column panel and select the mapping value that you want to map it to.
  13. To link the data value to the mapping value, click the
    Add Link
    button.
    An arrow appears to indicate the mapping value that the data value is linked to.
  14. Repeat steps 12 and 13 to link each data value to a mapping value.
  15. Click
    OK
    .