•  Data integration tasks
  •  Data filters
    •  Simple data filters
    •  Advanced data filters
    •  Data filter operators
    •  Data filter variables
    •  Rules and guidelines for data filters
  •  Field metadata
  •  Field expressions
    •  Creating a field expression
    •  Transformation language components for expressions
    •  Expression syntax
    •  String and numeric literals
    •  Rules and guidelines for expressions
    •  Adding comments to expressions
    •  Reserved words
  •  Advanced session properties
  •  Advanced session properties in advanced mode
  •  Parameter files
  •  Serverless usage properties
  •  Schedules
    •  Repeat frequency
    •  Time zones and schedules
    •  Daylight Savings Time changes and schedules
    •  Creating a schedule
    •  Running a task on a schedule
  •  Email notification
  •  Preprocessing and postprocessing commands
    •  Preprocessing and postprocessing SQL commands
    •  Preprocessing and postprocessing operating system commands
  •  Monitoring a job
  •  Data catalog discovery for sources
    •  Catalog search
    •  Discovering and selecting a catalog object
  •  Stopping a job
  •  Guidelines for sources and targets in data integration tasks
    •  Rules and guidelines for flat file sources and targets
    •  Rules and guidelines for database sources and targets
•  Mapping tasks
  •  Mapping task templates
  •  Related objects
  •  Advanced relationships
  •  Spark session properties
  •  SQL ELT optimization
    •  SQL ELT optimization in advanced mode
  •  Runtime strategies
  •  CDC runtime properties in mapping tasks
  •  Simultaneous task runs
  •  Schema change handling
    •  Dynamic schema handling options
    •  Dynamic schema change handling rules and guidelines
  •  Schema mismatch handling
  •  Mapping task configuration
    •  Creating a mapping task
    •  Configuring sources
    •  Configuring targets
    •  Configuring CDC runtime properties
    •  Configuring input parameters
    •  Configuring persistent values
    •  Configuring runtime options
    •  Configuring the runtime strategy
  •  CLAIRE Tuning
    •  Guidelines to get an accurate recommendation
    •  Configuring tuning
    •  Initial tuning
    •  Initial tuning results
    •  Continuous tuning
  •  Viewing and editing mapping task details
    •  Sequence values
  •  Running a mapping task
    •  Reprocessing incrementally-loaded source files
•  Dynamic mapping tasks
  •  Parameters in dynamic mapping tasks
    •  Parameter scope
    •  Parameter settings
  •  Jobs and job groups
    •  Job settings
  •  Schema change handling
    •  Schema change handling options
  •  Configuring a dynamic mapping task
    •  Defining a dynamic mapping task
    •  Configuring default parameters
    •  Configuring jobs
    •  Configuring groups
    •  Configuring runtime options
•  Synchronization tasks
  •  Task operations
  •  Synchronization task sources
    •  Rules and guidelines for multiple-object databases
  •  Synchronization task targets
    •  Flat file target creation
    •  Database target truncation
    •  Salesforce targets and IDs for related objects
    •  Update columns
  •  Column names in flat files
  •  Field mappings
    •  Field data types
    •  Mapplets in field mappings
    •  Lookup conditions
    •  Lookup return values
    •  Rules and guidelines for lookups
  •  Configuring a synchronization task
    •  Synchronization prerequisite tasks
    •  Defining a synchronization task
    •  Configuring the source
    •  Configuring the target
    •  Configuring the data filters
    •  Configuring the field mapping
    •  Configuring a schedule and advanced options
  •  Viewing synchronization task details
  •  Running a synchronization task
    •  Rules and guidelines for running a synchronization task
•  Data transfer tasks
  •  Task operations
  •  Data transfer task sources
    •  Source filters
    •  Sort conditions
    •  Custom queries
  •  Second sources
    •  Lookup condition
    •  Second source filters
  •  Data transfer task targets
    •  Database target truncation
    •  Update columns
  •  Field mapping
  •  Field data types
  •  Configuring a data transfer task
    •  Defining the data transfer task
    •  Configuring the source
    •  Configuring a second source
    •  Configuring the target
    •  Configuring the field mapping
    •  Configuring runtime options
  •  Running a data transfer task
•  Replication tasks
  •  Load types
    •  Full load
  •  Replication task sources
  •  Replication task targets
    •  Replicate data to a database target
    •  Replicate data to a flat file target
  •  Reset a database target
    •  Resetting a target table
    •  Rules and guidelines for resetting a target table
  •  Table and column names in a database target
    •  Table name truncation
    •  Duplicate tables names from same replication task
    •  Duplicate table names from different replication tasks
    •  Column name truncation
  •  Target prefixes
  •  Creating target tables
  •  Replication task schedules
  •  Configuring a replication task
    •  Rules and guidelines for configuring replication tasks
    •  Replication prerequisite tasks
    •  Defining a replication task
    •  Configuring the source
    •  Configuring the target
    •  Configuring the field exclusions
    •  Configuring the data filters
    •  Configuring a schedule and advanced options
  •  Viewing replication task details
  •  Running a replication task
    •  Rules and guidelines for running a replication task
•  Masking tasks
  •  Rules and guidelines for masking tasks
  •  Masking task options
  •  Source objects
    •  Schema graph
  •  Target task operations
    •  Inplace masking
    •  Update partial sandbox
    •  Refresh fields
    •  Validation reports
  •  Staging database
    •  Start the staging connection
    •  H2 database configuration 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
  •  Refresh metadata
  •  Reset task
  •  Apply masking rules
    •  Masking rule assignments
    •  Add mapplets
    •  Target fields
    •  Default masking rules package
  •  Schedule options
    •  Email notification options
    •  Advanced options
  •  Configuring a masking task
    •  Prerequisites
    •  Step 1. Define the 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 masking task
  •  Masking task maintenance
    •  Editing a masking task
    •  Running a masking task manually
    •  Refreshing the metadata in a masking task
    •  Stopping a masking task
    •  Resetting a masking task
    •  Configuring masking task permissions
    •  Copying a masking task
    •  Renaming a masking task
    •  Deleting a masking task
    •  Exporting a masking task
    •  Downloading mapping XML
    •  Downloading validation reports
  •  Dictionary files for data masking
  •  Consistent masked output
    •  Rules and guidelines
    •  Example
•  Masking rules
  •  Masking rules
  •  Repeatable output
    •  Seed value
    •  Optimize dictionary usage
    •  Unique Substitution
  •  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 parameters
  •  Custom substitution masking
    •  Custom substitution masking parameters
    •  Custom substitution lookup example
    •  Custom substitution dictionary lookup use cases
  •  Dependent masking
    •  Dependent masking parameters
  •  URL masking
  •  Custom masking
  •  Mapplet masking
•  PowerCenter tasks
  •  PowerCenter workflows
    •  Supported transformations and mapping objects
    •  Exception handling in stored procedures
    •  Pre-session and post-session commands
  •  Rules and guidelines for PowerCenter sources and targets
  •  FTP/SFTP connections for PowerCenter tasks
  •  Web Service connections for PowerCenter tasks
  •  Parameters in PowerCenter tasks
  •  PowerCenter task configuration
    •  Configuring a PowerCenter task
  •  Running a PowerCenter task

Data integration tasks

Running a PowerCenter task

TASKS_LEARN_MORE

DI_TASKS_MOD_HYLNK

WIZ_DATAFILTERS

HL_DataFilterVariables

DI_WIZ_FIELDEXPRESSION_PAGE

CMD_EXPRESSION_DIALOG

SCHEDULES_PAGE

VIEW_SCHEDULE_PAGE

NEW_SCHEDULE_DIALOG

DATA_CATALOG_SEARCH_RESULTS

MT_TASKS_PAGE_LIST

MT_RESTART

HL_SQLELTOptimization

MCT_RUNTIME_STRATEGY

MTT_WIZ_SET_CDC_RUNTIME

MCT_NEW_TASK_CONFIG

MCT_SELECT_SOURCES

MCT_SELECT_TARGETS

MCT_SELECT_INPUT_PARAMETERS

MCT_SELECT_PERSISTENT_VALUES

MCT_SELECT_RUNTIME_OPTIONS

MCT_TUNING_CONFIGURE

MCT_TUNING_RESULTS

MCT_TUNING_PASSIVE

MT_TASK_PAGE

MTT_WIZ_SET_STATE

INCREMENTAL_FILE_LOAD_TIME_TRAVEL

DMT_TASK_PAGE

JOB_SETTINGS

CONFIG_JOBS

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

DI_WIZ_EDIT_FIELD_DATATYPES

DSS_WIZ_ASSIGN_SCHEDULE

DI_WIZ_UPDATECOLUMNS

DI_TASK_PAGE

DTT_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

VIEW_REPLICATION_GROUP_PAGE

DMASKS_LIST_PAGE

DMASK_WIZ_CREATE_NEW_TASK

DMASK_WIZ_SELECT_SOURCE

DMASK_WIZ_SELECT_TARGET

DMASK_WIZ_DEFINE_SUBSET

DMASK_WIZ_ASSIGN_SCHEDULE

DMASK_WIZ_DEFINE_MASKRULES

PCSTASKS_PAGE

EDIT_PCSTASK_PAGE

VIEW_PCSTASK_PAGE