Field Expressions
You can transform the source data before loading it into the target. When you configure field mappings, you can specify an expression for each field mapping. You can map multiple source fields to the same target field. For example, you map SourceFieldA and SourceFieldB to TargetFieldC.
Informatica Cloud 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, Informatica Cloud concatenates the source text fields by default. You can change the default expression.
Informatica Cloud 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.
To create a field expression, perform the following steps in the task wizard:
1. In the Field Mappings page, select the target field for which you want to add an expression.
2. Click Add or Edit Expression.
By default, the Field Expression dialog box shows the source field as the expression, which indicates that the target contains the same value as the source.
3. Enter the new field expression.
4. Click Validate Mapping to validate the field mappings.
5. Click Save.