Multiple choice technology

Which stage is used to calculate Standard Deviation?

  1. Transformer

  2. Aggregator

  3. Merge

  4. None of the above

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

The Aggregator stage in DataStage is specifically designed for performing aggregate calculations like SUM, AVG, MIN, MAX, and Standard Deviation. While you can write custom code in a Transformer stage to calculate standard deviation, the Aggregator stage has built-in functions for statistical calculations including standard deviation, making it the appropriate stage choice. Therefore option B (Aggregator) is correct.