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

.