Transformation language components for expressions
The transformation language includes the following components to create simple or complex expressions:
•Fields. Use the name of a source field to refer to the value of the field.
•Literals. Use numeric or string literals to refer to specific values.
•Functions. Use these SQL-like functions to change data in a task.
•Operators. Use transformation operators to create expressions to perform mathematical computations, combine data, or compare data.
•Constants. Use the predefined constants to reference values that remain constant, such as TRUE.
In mappings in SQL ELT mode, you use your cloud data warehouse's native expression components to create expressions. You don't use the Informatica transformation language to create expressions.