Data Integration Performance Tuning

Back Next

Replacing common expressions with local variables

If you use the same expression multiple times in one transformation, you can make that expression a local variable.

You can use a local variable only within the transformation. However, by calculating the variable only once, you speed up performance.