•  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
  •  Parameter files
  •  Schedules
    •  Repeat frequency
    •  Time zones and schedules
    •  Daylight Savings Time changes and schedules
    •  Creating a schedule
    •  Running a task on a schedule
    •  Removing a task from a schedule
  •  Email notification
  •  Preprocessing and postprocessing commands
    •  Preprocessing and postprocessing SQL commands
    •  Preprocessing and postprocessing operating system commands
  •  Monitoring a job
  •  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
  •  SQL ELT optimization
  •  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 input parameters
    •  Configuring persistent values
    •  Configuring runtime options
  •  Viewing and editing mapping task details
    •  Sequence values
  •  Running a mapping 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
•  Data loader tasks
  •  Step 1. Connect to your source
    •  Guidelines for customizing your source
    •  Selecting source objects
    •  Defining the source format
    •  Selecting source fields
    •  Configuring filters
    •  Selecting primary key fields
    •  Selecting watermark fields
  •  Step 2. Connect to your target
    •  Incremental loading
    •  Dropping and re-creating target tables
  •  Step 3. Run the task
    •  Running the task on a schedule
    •  Configuring email notifications
    •  Handling runtime errors
    •  Configuring the task location
    •  Runtime environment

Data integration tasks

Step 3. Run the 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

MT_TASKS_PAGE_LIST

MT_RESTART

HL_SQLELTOptimization

MCT_NEW_TASK_CONFIG

MCT_SELECT_SOURCES

MCT_SELECT_TARGETS

MCT_SELECT_INPUT_PARAMETERS

MCT_SELECT_PERSISTENT_VALUES

MCT_SELECT_RUNTIME_OPTIONS

MT_TASK_PAGE

MTT_WIZ_SET_STATE

DTT_TASK_PAGE

DLT_TASKS_PAGE

DLT_TASK_PAGE

DATA_LOADER_TASKS_PAGE_LIST

DLT_CONNECTSOURCE_PAGE

DLT_SOURCECONFIGOPTIONS

DESIGNER_OBJECT_SEARCH

DLT_DEFINESRCOBJS

DLT_EXCLUDESRCOBJ_DIALOG

DLT_INCLUDESRCOBJ_DIALOG

DLT_SELECTSOURCEPATH_DIALOG

DLT_DEFSOURCEFMT_DIALOG

DLT_EXCLUDESSRCFIELDS_DIALOG

DLT_FILTERS_DIALOG

DLT_PK_DIALOG

DLT_WATERMARKKEY_DIALOG

DLT_CONNECTTARGET_PAGE

DLT_SELECTTARGETPATH_DIALOG

DLT_LETSGO_PAGE

DLT_BROWSE_DIALOG