•  Working with Tasks
  •  Task Flows
    •  Configuring a Task Flow
    •  Running a Task Flow
  •  Data Filters
    •  Simple Data Filters
    •  Advanced Data Filters
    •  Data Filter Operators
    •  Data Filter Variables
    •  Rules and Guidelines for Data Filters
  •  Field Expressions
    •  Validating Expressions in Field Mappings
    •  Transformation Language Components for Expressions
    •  Expression Syntax
    •  String and Numeric Literals
    •  Rules and Guidelines for Expressions
    •  Adding Comments to Expressions
    •  Reserved Words
  •  Email Notification
  •  Parameter Files
•  Mapping Configuration Tasks
  •  Mapping Configuration Task Configuration
    •  Advanced Connection Properties for Integration Templates
    •  Related Source Configuration
    •  Advanced Relationships
    •  Advanced Session Properties
    •  Field Metadata
    •  Pushdown Optimization
    •  Defining the Mapping Configuration Task
    •  Configuring Sources
    •  Configuring the Target
    •  Configuring Parameters
    •  Sequence Generator Configuration
    •  Configuring a Schedule and Advanced Options
  •  Mapping Configuration Task Maintenance
    •  Viewing Mapping Configuration Task Details
    •  Copying a Mapping Configuration Task
    •  Running a Mapping Configuration Task
  •  Troubleshooting a Mapping Configuration Task
•  Data Synchronization Tasks
  •  Data Synchronization Prerequisite Tasks
  •  Data Synchronization Task Operations
    •  Insert Task Operation
    •  Update Task Operation
    •  Upsert Task Operation
    •  Delete Task Operation
  •  Data Synchronization Task Options
    •  Data Synchronization Task Sources
    •  Data Synchronization Task Targets
    •  Column Names in Flat Files
    •  Rules and Guidelines for Data Synchronization Task Sources and Targets
    •  Field Mappings
    •  Data Synchronization Task Schedule and Advanced Options
  •  Data Synchronization Task Configuration
    •  Step 1. Define the Data Synchronization Task
    •  Step 2. Configure the Source
    •  Step 3. Configure the Target
    •  Step 4. Configure the Data Filters
    •  Step 5. Configure the Field Mapping
    •  Step 6. Configure a Schedule and Advanced Options
  •  Viewing Data Synchronization Task Details
  •  Copying a Data Synchronization Task
  •  Running a Data Synchronization Task
    •  Rules and Guidelines for Running a Data Synchronization Task
    •  Running a Data Synchronization Task Manually
    •  Running a Data Synchronization Task on a Schedule
  •  Stopping a Data Synchronization Task
  •  Monitoring a Data Synchronization Task
  •  Downloading Mapping XML
  •  Deleting a Data Synchronization Task
•  Data Replication Tasks
  •  Load Types
    •  Full Load
  •  Data Replication Task Sources
  •  Data Replication Task Targets
    •  Replicate Data to a Database Target
    •  Replicate Data to a Flat File Target
  •  Reset a Database Target
    •  Resetting a Target
    •  Rules and Guidelines for Resetting a Target Table
  •  Table and Column Names in a Database Target
    •  Table Name Truncation
    •  Duplicate Tables Names from Same Data Replication Task
    •  Duplicate Table Names from Different Data Replication Tasks
    •  Column Name Truncation
  •  Data Replication Prerequisite Tasks
  •  Data Replication Task Configuration
    •  Rules and Guidelines for Configuring Data Replication Tasks
    •  Step 1. Configure the Source
    •  Step 2. Configure the Target
    •  Step 3. Configure the Field Exclusions
    •  Step 4. Configure the Data Filters
    •  Step 5. Configure a Schedule
  •  Viewing Data Replication Task Details
  •  Copying a Data Replication Task
  •  Run a Data Replication Task
    •  Rules and Guidelines for Running a Data Replication Task
    •  Running a Data Replication Task Manually
    •  Running a Data Replication Task on a Schedule
  •  Stopping a Data Replication Task
  •  Monitoring a Data Replication Task
  •  Deleting a Data Replication Task
•  Data Masking Task
  •  Data Masking Overview
  •  Data Masking Task Options
  •  Source Objects
    •  Schema Graph
  •  Target Task Operations
    •  Inplace Masking
    •  Update Partial Sandbox
    •  Refresh Fields
    •  Validation Reports
  •  Staging Database
    •  Configure Staging Connection
    •  H2 Database Requirements
    •  Installing and Configuring H2 Database Manually on Windows
    •  Installing H2 Database Manually on Linux
  •  Data Subset
    •  Data Subset Options
    •  Automatic Task Recovery
    •  Parameter Files in Data Filters
  •  Configure Relationship Behavior
  •  Data Subset Use Cases for Two Objects
    •  Case 1. Select the default path with filter on Account
    •  Case 2. Select the configured path with filter on Account
    •  Case 3. Select the default path with filter on Contact
    •  Case 4. Select the configured path with filter on Contact
  •  Data Subset Use Cases for Three Objects
    •  Case 1. Default Path
    •  Case 2. Configured Path
  •  Data Subset Rows
    •  Data Subset Rows Example
  •  Apply Masking Rules
    •  Masking Rule Assignments
    •  Add Mapplets
    •  Target Fields
    •  Default Masking Rules Package
  •  Schedule Options
    •  Email Notification Options
    •  Advanced Options
  •  Configuring a Data Masking Task
    •  Prerequisites
    •  Step 1. Define the Data Masking Task
    •  Step 2. Configure the Source
    •  Step 3. Configure the Target
    •  Step 4. Configure the Data Subset
    •  Step 5. Define Data Masking Rules
    •  Step 6. Schedule the Data Masking Task
  •  Data Masking Task Maintenance
    •  Editing a Data Masking Task
    •  Running a Data Masking Task Manually
    •  Stopping a Data Masking Task
    •  Configuring Data Masking Task Permissions
    •  Copying a Data Masking Task
    •  Deleting a Data Masking Task
    •  Downloading Mapping XML
    •  Downloading Validation Reports
  •  Dictionary Files for Data Masking
•  Data Masking Rules
  •  Masking Rules Overview
  •  Masking Rules
  •  Repeatable Output
    •  Seed Value
  •  Preprocessing and Postprocessing Expressions
  •  Credit Card Masking
    •  Credit Card Parameters
  •  Email Masking
    •  Advanced Email Masking
  •  IP Address Masking
  •  Key Masking
    •  Key String Masking
    •  Key Numeric Masking
    •  Key Date Masking
  •  Nullification Masking
  •  Phone Number Masking
  •  Random Masking
    •  Random String Masking
    •  Random Numeric Masking
    •  Random Date Masking
  •  SIN Masking
  •  SSN Masking
  •  Substitution Masking
    •  Substitution Masking with Custom Dictionaries
    •  Substitution Masking Parameters
    •  Custom Substitution Lookup Example
    •  Custom Substitution Dictionary Lookup Use Cases
  •  URL Masking
  •  Custom Masking
  •  Mapplet Masking
•  Contact Validation Tasks
  •  Phone Number Validation Prerequisites
  •  Sources
  •  Output Files
    •  Output File Details and Field Names
    •  Scripts in Output Files
    •  Date Formats in Output Files
  •  Configure a Contact Validation Task
    •  Step 1. Define the Contact Validation Task
    •  Step 2. Configure the Source
    •  Step 3. Configure the Data Filters
    •  Step 4. Configure Validation Fields
    •  Step 5. Configure the Output File Details
    •  Step 6. Configure a Schedule and Advanced Options
    •  View Contact Validation Task Details
  •  Copying a Contact Validation Task
  •  Run a Contact Validation Task
    •  Running a Contact Validation Task Manually
    •  Running a Contact Validation Task on a Schedule
  •  Stop a Contact Validation Task
  •  Monitoring a Contact Validation Task
  •  Deleting a Contact Validation Task
•  Contact Validation Status Codes
  •  Address Validation
    •  Address Validation Status Output Fields
    •  Address Data Process Codes
    •  Address Data Status Codes
    •  Address Element Result Codes
    •  Certification System Fields
  •  Geocoding Information
    •  Geocoding Output Field
    •  Geocoding Status Codes
  •  Email Validation
    •  Email Address Validation Status Output Fields
    •  Email Status Codes
  •  Phone Number Validation
    •  Phone Number Validation Status Output Fields
    •  Phone Number Status Codes
•  Data Quality Services
  •  Data Quality Packages
  •  Configure a Data Quality Service
  •  Selecting a Data Quality Service
  •  Data Quality Services
  •  Downloading a WSDL
  •  Downloading a Sample Mapplet
  •  Configuring the SOAP Application
  •  Running the Application
    •  User Authentication
•  PowerCenter Tasks
  •  PowerCenter Prerequisite Tasks
  •  Supported Transformations and Mapping Objects
    •  Exception Handling in Stored Procedures
  •  Pre-Session and Post-Session Commands
  •  Sources and Targets
  •  FTP/SFTP Connections for PowerCenter Tasks
  •  PowerCenter Task Configuration
    •  Rules and Guidelines for Configuring a Workflow XML File and PowerCenter Task
    •  Configuring a PowerCenter Task
  •  Viewing PowerCenter Task Details
  •  Running a PowerCenter Task
    •  Rules and Guidelines for Running a PowerCenter Task
    •  Running a PowerCenter Task Manually
    •  Running a PowerCenter Task on a Schedule
  •  Stopping a PowerCenter Task
  •  Monitoring a PowerCenter Task
  •  Deleting a PowerCenter Task
•  Data Assessment Tasks
•  Schedules
  •  Configuring Blackout Periods
  •  Repeat Frequency
  •  Time Zones and Schedules
  •  Daylight Savings Time Changes and Schedules
  •  Configuring a Schedule
•  Stopping a Job

Working with Tasks

Stopping a Job

WORKFLOWS_PAGE

EDIT_WORKFLOW_PAGE

VIEW_WORKFLOW_PAGE

WIZ_DATAFILTERS

DI_WIZ_FIELDEXPRESSION_PAGE

CMD_EXPRESSION_DIALOG

MT_TASKS_PAGE_LIST

MTT_WIZ_CREATE_NEW_TASK

MTT_WIZ_SELECT_SOURCE

MTT_WIZ_SELECT_TARGET

MTT_WIZ_SELECT_OTHER

MTT_WIZ_SET_STATE

MTT_WIZ_SET_SCHEDULE

MT_TASK_PAGE

INTEGRATION2_TASKS_PAGE_LIST

DI_WIZ_CREATETARGET_PAGE

DI_WIZ_RELATEDOBJECTS_PAGE

EDIT_FIELD_DATATYPES

DSS_WIZ_PLUGIN_PAGE

DI_WIZ_FIELDLOOKUP_PAGE

DSS_WIZ_CREATE_NEW_TASK

DSS_WIZ_SELECT_SOURCE

INTEG_WIZ_SOURCE_PAGE

DSS_WIZ_SELECT_TARGET

DSS_WIZ_CREATE_DATA_FILTERS

DSS_WIZ_CONFIG_FIELD_MAPPINGS

CREATE_LOOKUP

DSS_WIZ_ADD_CUSTOM_FUNCTION

DSS_WIZ_ASSIGN_SCHEDULE

DI_TASK_PAGE

DATAREP_SETUP_PAGE

REPLICATION_GROUPS_PAGE_LIST

EDIT_REPLICATION_GROUP_PAGE

NEW_REPLICATION_GROUP_PAGE

DR_WIZ_SOURCE_PAGE

DR_WIZ_SELECTOBJECTS

DR_WIZ_TARGET_PAGE

DR_WIZ_FIELDEXCLUSION_PAGE

DR_WIZ_EDIT_FILTER_PAGE

DR_WIZ_EXCLUDEFIELDS

DR_WIZ_FILTERS_PAGE

DR_WIZ_SCHEDULE_PAGE

DR_WIZ_SCHEDULE_PAGE

VIEW_REPLICATION_GROUP_PAGE

DMASKS_LIST_PAGE

DMASK_WIZ_CREATE_NEW_TASK

DMASK_WIZ_SELECT_SOURCE

DMASK_WIZ_SELECT_TARGET

DMASK_WIZ_ASSIGN_SCHEDULE

DMASK_WIZ_DEFINE_MASKRULES

AVS_TASKS_PAGE_LIST

AVS_WIZ_CREATE_NEW_TASK

AVS_WIZ_SELECT_SOURCE

AVS_WIZ_CREATE_DATA_FILTERS

AVS_WIZ_CONFIG_FIELD_MAPPINGS

AVS_WIZ_SELECT_TARGET

AVS_WIZ_ASSIGN_SCHEDULE

AVS_TASK_PAGE

DQSERVICES_PAGE

EDIT_DQSERVICE_PAGE

PCSTASKS_PAGE

EDIT_PCSTASK_PAGE

VIEW_PCSTASK_PAGE

DQ_SETUP_PAGE

DQ_PLANS_PAGE_LIST

SCHEDULES_PAGE

VIEW_SCHEDULE_PAGE

NEW_SCHEDULE_PAGE

EDIT_SCHEDULE_PAGE

NEW_SCHEDULE_DIALOG