For each source field, you can perform a lookup or create an expression. You cannot do both.

You cannot use strings in numeric expressions.

You cannot use strings as numeric parameters.

You cannot mix data types when using comparison operators.

You can pass a value from a field, literal string or number, or the results of another expression.

Separate each argument in a function with a comma.

Except for literals, the transformation language is not case sensitive.

The colon (:), comma (,), and period (.) have special meaning and should be used only to specify syntax.

Data integration tasks treat a dash (-) as a minus operator.

If you pass a literal value to a function, enclose literal strings within single quotation marks. Do not use quotation marks for literal numbers. Data integration tasks treat any string value enclosed in single quotation marks as a character string.

Do not use quotation marks to designate fields.

You can nest multiple functions within an expression. Data integration tasks evaluate the expression starting with the innermost function.

When you use a parameter in an expression, use the appropriate function to convert the value to the necessary data type. For example, you might use the following expression to define a quarterly bonus for employees:

IIF((EMP_SALES < TO_INTEGER($$SalesQuota), 200, 0)