Data Integration Performance Tuning

Back Next

Using operators instead of functions

Mappings read expressions written with operators faster than expressions with functions. Where possible, use operators to write expressions.

For example, you have the following expression that contains nested CONCAT functions:

CONCAT( CONCAT( CUSTOMERS.FIRST_NAME, ‘ ’) CUSTOMERS.LAST_NAME)

You can rewrite that expression with the || operator as follows:

CUSTOMERS.FIRST_NAME || ‘ ’ || CUSTOMERS.LAST_NAME