View Course Agenda

Test Data Management for Developers

Instructor Led | Data Security | 3 Days | Version 10.2

Test Data Management for Developers

Course Overview

This course is applicable for version 10.2. Learn to discover and mask sensitive data on non-production environments and gain the skills required to define data domains to discover sensitive data based on data and metadata patterns. Use the out-of-the box masking techniques to mask data while retaining the original characteristics and define custom masking rules to handle complex data masking requirements.

Enroll Now 


After successfully completing this course, students should be able to:

  • Discover sensitive data through data domains
  • Identify sensitive data through data discovery
  • Describe use cases for persistent data masking and dynamic data masking
  • Create and manage a TDM project
  • Profile data to discover sensitive data
  • Mask data based on out-of-the-box masking techniques
  • Create custom TDM masking rules
  • Export TDM masking rules to and from PowerCenter
  • Override masking parameters
  • Cascade masking values to child tables
  • Create rule assignments
  • Generate and execute workflows from TDM

Target Audience

  • Developer


  • None


Module 1: Introduction to Test Data Management

  • Sensitive Data
  • Government regulations
  • Persistent data masking use cases
  • Dynamic Data Masking use cases
  • TDM Data masking and terminology
  • Architecture and deployment
  • TDM user interface
  • TDM Project and permissions
  • Lab: Create connections
  • Lab: Import data sources to a project

Module 2: Data Discovery

  • Data discovery overview
  • Profiling types
  • Discover constraints
  • Discover entities
  • Discover data domains
  • Table classification
  • Lab: Discover constraints
  • Lab: Discover entities
  • Lab: Discover sensitive data
  • Lab: Discover data domains and profile

Module 3: Data Subset

  • Define entities
  • Configure major and minor relationships
  • Create functional data subsets
  • Lab: Create subset with minor relationships
  • Lab: Create subset with major relationships
  • Lab: Create a subset with major and minor relationships

Module 4: Data Masking

  • Data Masking process and components
  • Data domains and profiling
  • Data masking rules
  • Table classification and cascade masked values
  • Override masking parameters
  • Configure out of the box masking rules
  • Lab: Credit card masking
  • Lab: Key masking
  • Lab: Nullification and shuffle masking
  • Lab: Random and Key masking
  • Lab: Encryption masking
  • Lab: Expression masking
  • Lab: SSN masking
  • Lab: Substitution masking
  • Lab: Conditional substitution masking
  • Lab: Email masking
  • Lab: Advanced masking

Module 5: Test Data Generation

  • Describe data generation use cases
  • Define data generation rules
  • Generate synthetic data
  • Lab: Generate test data

Module 6: Test Data Warehouse

  • Describe Test data warehouse
  • Define test data warehouse components
  • Define datasets
  • Restore datasets
  • Lab: Define dataset
  • Lab: Restore dataset 

    Enroll Now 

    Back to Course Overview


    Instructor Led | Data Security | 3 Days | Version 10.2

    Print Friendly and PDF