Multiple choice technology

Which of the following function can not be used in an expression transformation?

  1. Variance

  2. Substr

  3. instr

  4. Add_to_date

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Variance is an aggregate statistical function that can only be used in Aggregator transformations in Informatica. Expression transformations support only single-row functions that operate on one row at a time, such as Substr, instr, and Add_to_date.