Use the expression editor to configure the expression field. The expression can contain constants, variables, built-in functions, and user-defined functions. You can also create a complex expression by nesting functions within functions.
To configure an expression, enter it in the expression editor.
The following image shows the expression editor and the actions you can perform:
1Parameterize the expression.
2Switch between fields, system variables, parameters, built-in functions, and user defined functions.
3Validate the expression.
You can add source fields, functions, and variables to the expression by clicking Add next to the object that you want to use. You can also type in the expression manually.
Alternatively, press the Ctrl + Space keys to see a list of recommended arguments and functions in-line. Data Integration provides recommendations based on the type of function arguments and keystrokes. In-line recommendations are not available for hierarchical source data.
To validate the expression, click Validate. Data Integration validates the expression.
In mappings in SQL ELT mode, the expression editor displays your cloud data warehouse's native functions instead of Informatica transformation language functions. Data Integration doesn't validate the expression. If you enter an invalid expression, the mapping fails at run time.
