Multiple choice technology

You are optimizing a Mapping. Which of the following statements about expressions is true?

  1. String operations are faster than numeric operations

  2. You should trim Char and Varchar fields before performing comparisons

  3. The CONCAT function is faster than the || operator

  4. Using a variable is less efficient than using the equivalent code in several expressions
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In PowerCenter's expression engine, string operations are generally faster than numeric operations due to internal processing architecture. Trimming before comparisons is unnecessary (PowerCenter handles this), || is faster than CONCAT(), and variables improve efficiency by avoiding repeated calculations.

Keep practicing — related questions