Multiple choice technology

Which is the most expensive stage

  1. Sort stage

  2. Transformer stage

  3. Modify stage

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Transformer stage is typically the most resource-intensive stage in ETL tools like IBM DataStage because it applies complex business logic and transformations to each record. Sort stages use significant memory for sorting, Modify stages are lightweight, and Transformer operations require more computational overhead than other passive stages.

Keep practicing — related questions