Multiple choice technology databases

Compare sorter transformation with order by clause on database?

  1. Sorter transformation is more faster

  2. Order by clause on database is more faster

  3. Both will take same time

  4. We cannot compare
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In Informatica PowerCenter, using a Sorter transformation can be faster because it utilizes the Integration Service's memory (cache) and parallel processing, avoiding database overhead and network roundtrips caused by database-level sorting via an 'ORDER BY' clause. However, performance varies based on database optimization, making the absolute claim debatable.

Keep practicing — related questions