Multiple choice technology databases

Which transformation has sorted input option available in the properties?

  1. Joiner, Sorter

  2. Aggregator, Update Strategy

  3. Aggregator, Joiner

  4. All of above

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

In Informatica PowerCenter, both Aggregator and Joiner transformations have a 'Sorted Input' property option. This allows optimization when input data is pre-sorted, improving performance by eliminating the need for internal sorting.