Tasks

Back Next

Field expressions

When you configure a

data transfer

task,

you can configure the field mapping. The field mapping defines how source fields are mapped to target fields. You can specify an expression for each field mapping.

You can map multiple source fields to the same target field. For example, you can map SourceFieldA and SourceFieldB to TargetFieldC.

Data Integration

might suggest operations when you map multiple source fields to a single target field. For example, if you map multiple text fields to a target text field,

Data Integration

concatenates the source text fields by default. You can change the default expression.

Data Integration

provides a transformation language that includes SQL-like functions to transform source data. Use these functions to write expressions, which modify data or test whether data matches the conditions that you specify.

For more information about functions and the

Data Integration

transformation language, see

Function Reference

Data integration tasks

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