Preface
Informatica Resources
Informatica Network
Informatica Knowledge Base
Informatica Documentation
Informatica Product Availability Matrixes
Informatica Velocity
Informatica Marketplace
Informatica Global Customer Support
Introduction to Test Data Management
Test Data Management Overview
Test Data Management Use Cases
Using TDM to Improve Performance in Application Testing Environments
Using TDM for Security and Compliance in Application Testing Environments
Using TDM With Data Validation Option to Create Verified Test Data
TDM Architecture
TDM Tools
TDM Server
Application Services
TDM Databases
TDM Process
Create a Data Masking Policy
Create a Project and Import Metadata
Discover Source Information
Define Data Masking and Data Subset Operations
Define a Data Generation Operation
Create a Plan for Data Masking and Data Subset
Create a Plan for Data Generation
Monitor the Workflow
TDM Example
Test Data Manager
Test Data Manager Overview
Test Data Manager User Interface
Views
Search Field
Quick Links Menu
User Preferences Menu
Actions Menu
Data Filter
Overview View
Dashboards
Project Risk Analysis
Project Assignments and Project Objects
Recent Project Sensitive Data Distribution
Recent Activities
Plan Execution
Global Components
Recent Projects
Policies View
Datasets View
Projects View
Monitor View
Administrator View
Expression Builder
Logging In to the Test Data Manager
Projects
Projects Overview
Project Components
Project Logs
Project Management
Creating a Project
Editing a Project
Copying a Project
Deleting a Project
Configuring Project Log Locations
Exporting a Project
Importing a Project
Data Sources
TDM Source Definitions
Hadoop Data Sources
XSD Data Sources
Editing the Properties of an Element in an XSD File
XSD Import Guidelines
PowerExchange Nonrelational Sources
Importing Data Sources
Identity Columns in TDM
Project Permission and Security
Project Permissions
Updating User and Group Security
Policies
Policies Overview
Policies View
Policies Task Flow
Data Masking Rules
Standard Masking Rules
Advanced Masking Rules
Mapplet Rules
Data Domains
Apply Masking Rules to a Data Domain
Apply Generation Rules to a Data Domain
Metadata and Data Patterns for Data Domains
Regular Expression Syntax
Data Patterns
Metadata Patterns
Data Domain Options
Creating a Data Domain
Copying a Data Domain
Editing a Data Domain
Deleting a Data Domain
Policy Packs
PII Policy Pack
PHI Policy Pack
PCI Policy Pack
Import and Export
Exporting Policy Components
Importing Policy Components
Data Domain Import
Linking Business Glossary Terms to Global Objects
Linking a Business Term to an Object
Deleting a Business Term Link to an Object
Policy Management
Creating a Policy
Copying a Policy
Editing a Policy
Deleting a Policy
Data Discovery
Data Discovery Overview
Data Discovery Sources
Rules and Guidelines for Data Discovery Sources
Discover View
Column Properties
Sensitive Columns
Value Cascades
Auto Cascades
Data Discovery Task Flow
Primary Key Discovery
Primary Key Profile Options
Entity Discovery
Entity Profile Options
Data Domain Discovery
Data Domain Profiling on Hive and HDFS Sources
Data Domain Profile Sampling Options
Assigning a Data Domain to Multiple Columns
Manually Updating the Column Data Domain
Column Profile
Inferred Rules
Column Profile Options
Profile Management
Creating a Primary Key Profile
Creating an Entity Profile
Creating a Data Domain Profile
Creating a Column Profile
Editing a Profile
Deleting a Profile
Profile Import
Importing a Profile
Apply the Results
Primary Key Results
Entity Discovery Results
Data Domain Discovery Results
Column Profile Results
Project Tables
Table Classification
Constraints
Manually Add Keys to Tables in a Project
Creating a Primary Key Constraint
Creating a Logical Relationship Between Tables
Creating a Unique Key Constraint
Creating a Conditional Constraint
Data Subset
Data Subset Overview
Data Subset Task Flow
Entities
Entity Example
Entities View
Entity Map View
Tables View
Relationships View
Review Changes
Entity Management
Creating an Entity
Parameter Values in Entity Criteria
Database Functions in Entity Criteria
Editing an Entity
Optimizing Relations
Exporting an Entity
Importing an Entity
Deleting an Entity
Groups
Creating a Group
Editing a Group
Copying a Group
Exporting a Group
Importing a Group
Deleting a Group
Templates
Template Example
Creating a Template
Editing a Template
Deleting a Template
Data Subset for XSD Sources
Data Subset for XSD Sources Task Flow
Applying Criteria to an Element or Attribute
Example - Data Subset for XSD Data Sources
Data Subset Plans and Workflows
Data Masking
Data Masking Overview
Data Masking Components
Data Masking Task Flow
Masking Rules Management
Modify Masking Rules
Editing a Masking Rule
Copying a Masking Rule
Deleting a Masking Rule
Masking Rule Assignments
Available Data Masking Rules
Assigning Masking Rules to Columns
Overriding a Masking Rule
Assigning Multiple Masking Rules to a Column
Assigning Default Values to Multiple Columns
Assigning Custom Masking Rules to Columns
Assigning Advanced Masking Rules to Columns
Deleting Masking Rule Assignments
Data Masking for XSD Sources
Data Masking Task Flow for XSD Sources
Applying Data Masking Rules to XML Elements and Attributes
Data Masking Plans and Workflows
Masking Components in PowerCenter
Mapplet Export
Data Masking Techniques and Parameters
Data Masking Techniques and Parameters Overview
Data Masking Techniques
Data Masking Parameters
Repeatable Output
Custom Masking
Custom Masking Parameters
Advanced Masking
Advanced Masking Parameters
Advanced Masking Example
Credit Card Masking
Credit Card Masking Parameters
Email Masking
Email Masking Parameters
Encryption Masking
Expression Masking
Expression Masking Parameters
Rules and Guidelines for Expression Masking
IP Address Masking
Key Masking
Mask Format
Source String Characters
Result String Replacement Characters
Date Key Masking
Numeric Key Masking Parameters
String Key Masking Parameters
Nullification Masking
Phone Masking
Random Masking
Range Masking
Blurring
Mask Format
Source String Characters
Result String Replacement Characters
Date Random Masking Parameters
Numeric Random Masking Parameters
String Random Masking Parameters
Shuffle Masking
Shuffle Masking Parameters
SIN Masking
SSN Masking
Substitution Masking
Substitution Masking Parameters
URL Masking
Name Substitution Example
Add a Dictionary in Test Data Manager
Creating the Substitution Rule
Creating the Advanced Masking Rule
Shuffle Address Example
Creating the Shuffle Rule
Create the Advanced Masking Rule
Data Generation
Data Generation Overview
Data Generation Components
Data Generation Task Flow
Data Generation Rule Types
Default Settings
Define Default Generation Rules
Standard Generation Rules
Creating a Standard Generation Rule
Editing a Generation Rule
Overriding a Generation Rule
Deleting a Generation Rule
Custom Generation Rules
Creating a Custom Generation Rule
Ad Hoc Generation Rules
Creating an Ad Hoc Generation Rule
Editing an Ad Hoc Generation Rule
Conditional Constraints
Conditional Constraints and Data Conflicts
Data Generation Rule Assignments
Available Data Generation Rules
Assigning Standard Generation Rules to Columns
Assigning Custom Generation Rules to Columns
Assigning Auto Rules to Columns
Deleting Generation Rule Assignments
Data Generation for XSD Sources
Data Generation Task Flow for XSD Sources
Applying Data Generation Rules to XML Elements and Attributes
Data Generation Plans and Workflows
Data Generation Techniques and Parameters
Data Generation Techniques and Parameters Overview
Data Generation Techniques
Data Generation Parameters
Exception Test Data
Custom Generation
Custom Generation Parameters
Dictionary Generation
Dictionary Generation Parameters
Effective Dates Generation
Effective Dates Generation Parameters
Effective Dates Generation Example
Expression Generation
Expression Generation Parameters
Random Generation
Date Random Generation Parameters
String Random Generation Parameters
Numeric Random Generation Parameters
Data Patterns for Random Generation
Reference Lookup Generation
Reference Lookup Generation Parameters
Sequence Generation
Date Sequence Generation Parameters
Numeric Sequence Generation Parameters
Set of Values Generation
Set of Values Generation Parameters
Working with Test Data Warehouse
Test Data Warehouse Overview
Data Sets
Data Set Versions
Data Set Version Tags
Locking and Unlocking a Data Set Version
Editing a Data Set Version
Data Sets Task Flow
Data Set Creation Guidelines
Data Sets View
Creating a Data Set
Data Set Version Properties
Creating a Data Set Version From a Single Plan
Creating a Data Set Version by Reusing The Data Set Name
Deleting a Data Set or a Data Set Version
Reset a Data Set Version
Classification of Data Set Version Tables
Classifying a Data Set Version Table
Reset With and Without Downtime
Resetting a Data Set Version
Reset Process Flow
Reset with Truncate Tables Process Flow
Reset Without Truncate Tables Process Flow
Restoring Deleted Data After a Failed Reset
Monitor a Data Set Version Job
Data Set Version Permissions
Editing Data Set Version Permission
Plans and Workflows
Plans and Workflows Overview
Plans and Workflows Task List
Workflow Connections
Plan Components
Persist Mapping
Plan Settings
Connection Options
Data Set Properties
Test Tool Integration Options
Target Options
Update Strategy Options
Data Generation Properties
Error and Recovery Options
Advanced Options
Log Settings
Masking Components
Subset Components
Generation Components
Hadoop Components
Component Criteria
Filtering Data Subset Components
Disabling Masking for a Column
Source Settings
Connection Properties
Test Tool Integration Properties
Target Properties
Update Strategy Properties
Error and Recovery Properties
Source and Target Properties
Advanced Properties
Partitioning Properties
XSD Data Source Connection Settings
XSD Data Source Advanced Settings
Plan Management
Creating a Data Masking and Data Subset Plan
Creating a Data Generation Plan
Creating an Ad Hoc Generation Plan
Creating a Hadoop Plan
Copying a Plan
Exporting a Plan
Importing a Plan
Deleting a Plan
Workflow Generation
Generating a Workflow
Export to HP ALM
Executing a Workflow
Workflow Executions View
Workflow Tasks
Workflow Properties Panel
Monitor
Monitor Overview
Jobs
Job Details
Monitor Tasks
Logs
Severity Levels
Viewing the Log Messages
Sessions
Monitoring for Hadoop
Reports
Reports Overview
Data Masking Report
Running the Data Masking Report
Plan Audit Report
Running a Plan Audit Report
Plan Detail Report
Running the Plan Detail Report
Row Count Report
Running the Row Count Report
Reports for Hadoop
ilmcmd
ilmcmd Overview
Configuring ilmcmd
Running ilmcmd
Entering Options and Arguments
Syntax Notation
Delete
Delete Examples
Export
Export Examples
Import
Import Examples
Search
Search Examples
Workflow
Workflow Examples
Reset
Register
tdwcmd
tdwcmd Overview
Configuring tdwcmd
Running tdwcmd
Entering Options and Arguments
Syntax Notation
Version
List
tdwquery
tdwquery Overview
Configuring tdwquery
Running tdwquery
Select Clause
Joins
Aggregate Functions
Where Clause
Additional Clauses
Data Type Reference
Data Type Reference Overview
Oracle
Microsoft SQL Server
DB2 for Linux, UNIX, and Windows
Sybase ASE
HDFS
Hive
MySQL
Flat File
VSAM
DB2 for z/OS
IMS Flat
Sybase IQ
Netezza
Teradata
Data Type Reference for Test Data Warehouse
Data Type Reference for Test Data Warehouse Overview
Oracle
Microsoft SQL Server
DB2 for Linux, UNIX, and Windows
Sybase ASE
Data Type Reference for Hadoop
Data Type Reference for Hadoop Overview
Oracle
Microsoft SQL Server
DB2 for Linux, UNIX, and Windows
Sybase ASE
Hive
HDFS
Flat File
Glossary
Glossary of Terms
Test Data Management (TDM)
accelerator
ad hoc generation rule
advanced masking
auto cascade
blurring
calculated masking
cascade
column profile
custom generation rule
data discovery
data generation
data masking
data subset
dependent masking
dictionary
dictionary generation
effective dates generation
encryption masking
entity
Expression Builder
expression generation
expression masking
foreign key profile
generation rule
group
ilmcmd
key masking
mask format
nullification masking
pattern
plan
policy
PowerCenter
profile
project
random generation
random masking
range
reference lookup generation
residual table
result string replacement characters
rule
rule qualifier
seed
sequence generation
set of values generation
shuffle masking
simulation masking
source string characters
standard generation rule
substitution masking
TDM repository
TDM Server
tdwcmd
tdwquery
template
Test Data Manager
test data mart
test data repository
test data warehouse
value cascade
Preface
Glossary
tdm.user.guide.preface
user.preferences
overview
dashboard.riskanalaysis.project
expression.builder
login
project
project.policies
project.define
project.additionalrules
project.create
project.folder
project.edit
project.change.owner
project.copy
project.delete
project.import
project.xml.import
xmlsource
xml.edit.general
import_PC_metadata
project.permission.edit
projectpermission.edit
project.security
project.security.users
project.security.groups
privacypolicies.policy
policy
rule.edit
rule.create
privacypolicies.rule
privacypolicies.rule.create
privacypolicies.rule.edit
domain.add.rules
rulesimulator
privacypolicies.datadomain
datadomain
datadomain.delete
policy.add.domains
privacypolicies.datadomain.edit
datadomain.edit
datadomain.create
datadomain.copy
policy.import.dialog
privacy.import.datadomains
businessterms.link
privacypolicies.policy.create
policy.create
policy.new
policy.copy
privacypolicies.policy.edit
policy.edit
project.discover.profile
profile
project.discover
project.discover.columns
project.discover.tables
relational.tableviewer
discovery.port.similarvalues
discovery.port.assignments
profile.copy
profile.create
profile.delete
profile.edit
discovery.profile.execute
discovery.profile.sources
discovery.profile.privacy
profile.import
discovery.source.classify
project.entity.constraint
discovery.source.constraint
project.define.subset
entity_details
project.define.subset.entity
project.entity.copy
project.driving.table
project.entity.criteria
project.define.subset.entity.change.review
project.entity.review
create_entity
table_search
create_entity_filter_parms
project.entity.create
add_entities_parms
update_entity
project.entity.edit
project.define.subset.entity.edit
entity.optimize.relations
project.entity.delete
project.define.subset.group
project.group.copy
project.group.sources
create_group
project.group.create
add_residual_tables_select_plans
add_residual_tables_verify_tables
update_group
project.group.edit
project.define.subset.group.edit
group.copy
project.template.copy
project.define.subset.template
project.template.create
template.create
project.template.entities
project.template.parameters
project.template.groups
project.template.edit
project.define.subset.template.edit
xml.edit.criteria
project.define.masking
rule.copy
project.define.masking.ruleassignment.create
ruleassignment.create
ruleassignment.edit
policy_assignment
port_search
ruleassignment.delete
xml.edit.masking
advanced.add.ports
advanced.add.rules
advanced.rule.override
rule.override
rule.dictionary
project.define.generation
generationrule
generationrule.create
generationrule.edit
generationrule.create
generationrule.edit
xml.edit.generation
tdwdatasetversion.edit
tdwdatasetversions
tdwdatasetversion.details
tdw.datasetversion.table.classification
tdwdatasetversion.reset
tdwdatasetversion.permissions.edit
project.plan
project.execute
sessions.tables.properties
project.plan.edit
project.plan.connections
project.plan.email
project.plan.masking
project.plan.subset
project.plan.limit
project.plan.partition
project.plan.create
project.hadoop.plan.create
plan.copy
project.plan.generateworkflow
project.plan.executeworkflow
project.plan.workflowexecution
project.monitor
jobs.logs