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

Assigning Advanced Masking Rules to Columns

Assigning Advanced Masking Rules to Columns

Assign an advanced masking rule to a column and map source input columns to the rule input and output ports. To perform expression cascade, you can add another table, select columns from the table, and map the input columns. An expression cascade joins the two tables to generate a combined masked output.
  1. In the
    Define | Data Masking
    view, click the
    Masking Rule
    column for the column that requires an advanced rule.
  2. Select the advanced rule from the list.
    The
    Advanced Rule Assignment
    dialog box appears with the list of columns in the table.
  3. To select columns from another table, click the
    Add Associated Table
    icon.
    The
    Add Associated Table
    dialog box appears.
  4. Select an associated table and click
    OK
    .
    The table name appears with a list of column.
  5. Select a source input column in the left panel and a rule input port in the right panel.
    When you select a source input column, the rule ports with same data type become available for mapping.
  6. Click the
    Link
    icon to create a mapping.
    An arrow appears that links the source port to the rule port.
    To create a mapping, you can also click
    Show Simple
    and map the ports.
  7. If you need to remove the link, select the source input port and the rule input port. Click the
    Unlink
    icon.
    The arrow between the ports disappears.
  8. After you map the rule input ports, click
    Next
    .
  9. Provide a join condition for the two source input tables to perform expression cascade.
  10. Click
    Next
    .
  11. Select a rule output port in the left panel and a source input column in the right panel.
  12. Click the
    Link
    icon to create a mapping. To remove a mapping, click the
    Unlink
    icon.
  13. Click
    Save
    .