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:
1. To configure a field expression in a new task, click Task Wizards > <task type> > New, complete the preliminary wizard steps, and then click Field Mapping.
To configure a field expression in an existing task, click Task Wizards > <task type>, click the name of the task, click Edit, and then click Field Mapping.
<task type> is the name of any of the tasks, such as the Data Synchronization task.
2. In the Field Mappings page, select the target field for which you want to add an expression.
3. 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.
4. Enter the new field expression.
5. Click Validate Mapping to validate the field mappings.
6. Click Save.