•  Mappings
  •  Mapping Designer
  •  Mapping templates
  •  Mapping configuration
    •  Defining a mapping
    •  Configuring the source
    •  Configuring the data flow
    •  Configuring the target
    •  Rules and guidelines for mapping configuration
    •  Data flow run order
  •  Mappings in SQL ELT mode
    •  Sources in mappings in SQL ELT mode
    •  Targets in mappings in SQL ELT mode
    •  Transformations in mappings in SQL ELT mode
    •  Mapping behavior differences
    •  Mapping configuration in SQL ELT mode
  •  Mapping validation
    •  Validating a mapping
    •  Validating a mapping in SQL ELT mode
  •  Data preview in mappings
    •  Preview behavior for a mapping
    •  Running a preview job for a mapping
    •  Viewing preview results for a mapping
    •  Customizing preview results
  •  Detailed data preview in mapplets
    •  Running detailed data preview in a mapplet
  •  SQL ELT query preview
    •  Running an SQL ELT query preview for mappings configured for SQL optimization
    •  Running an SQL ELT query preview for mappings in SQL ELT mode
    •  SQL ELT query preview results files
    •  SQL ELT query data preview
    •  Running an SQL ELT query data preview job
  •  Field lineage
    •  Lineage for renamed fields
    •  Lineage for fields containing expressions
    •  Lineage for mapped fields
    •  Mapplet field lineage
    •  Lineage for lookup fields
    •  Viewing field lineage
  •  Testing a mapping
  •  Mapping maintenance
  •  Mapping revisions and mapping tasks
•  Mapping tutorial
  •  Mapping tutorial steps
  •  Preparing for the mapping tutorial
  •  Step 1. Create the mapping
  •  Step 2. Configure the source
  •  Step 3. Create the Filter transformation
  •  Step 4. Configure the target
  •  Step 5. Validate and test the mapping
  •  Step 6. Create a mapping task
•  Parameters
  •  Input parameters
    •  Input parameter types
    •  Input parameter configuration
    •  Partial parameterization with input parameters
    •  Using parameters in a mapping
  •  In-out parameters
    •  Aggregation types
    •  Variable functions
    •  In-out parameter properties
    •  In-out parameter values
    •  Rules and guidelines for in-out parameters
    •  Creating an in-out parameter
    •  Editing in-out parameters in a mapping task
    •  In-out parameter example
    •  Using in-out parameters as expression variables
    •  Using in-out parameters as source queries
  •  Parameter files
    •  Parameter file requirements
    •  Parameter scope
    •  Sample parameter file
    •  Parameter file location
    •  Rules and guidelines for parameter files
    •  Parameter file templates
    •  Overriding connections with parameter files
    •  Overriding data objects with parameter files
    •  Overriding source queries
    •  Creating target objects at run time with parameter files
•  CLAIRE recommendations
  •  Transformation type recommendations
  •  Source recommendations
    •  Join recommendations
    •  Union recommendations

Mappings

Source recommendations

MAPPING_LIST_PAGE

MAPPINGS_LEARN_MORE

DI_MAP_MOD_HYLNK

MAPPING_ELT_CHOOSETYPE

HL_Mappings

MAPPING_DESIGNER

CMD_FLOW_ORDER_DIALOG

MAPPING_ELT_CHOOSEPLATFORM

MAPPING_ELT_CHOOSECONN

MAPPING_ELT_DATASOURCES

MAPPING_ELT_TARGETS

MAPPING_ELT_CREATE

MTT_WIZ_DATA_PREVIEW

MTT_WIZ_PDO_PREVIEW_SQL

MAPPING_ELT_QUERYPREVIEW

MTT_WIZ_PDO_PREVIEW_RESULTS

MAPPING_TEST_RUN

CMD_PARAMETER_DIALOG

CMD_VARIABLE_DIALOG

MTT_WIZ_SET_IN_OUT_PARAMETERS

HL_PARAMFILELOC