Multiple choice technology

Which three actions can improve sort performance in a DataStage job? (Choose three.)

  1. Specify only the key columns which are necessary.

  2. Use the stable-sort option to avoid the random ordering of non-key data.

  3. Minimize the number of sorts used within a job flow.

  4. Adjusting the "Restrict Memory Usage" option in the Sort stage.

  5. Run the job sequentially so that only one sort process is invoked.
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

Specifying only necessary key columns reduces the sorting overhead by minimizing the data being compared. Minimizing the number of sorts in a job flow reduces total processing time. The 'Restrict Memory Usage' option can improve performance by controlling memory allocation and avoiding excessive disk swapping when dealing with large datasets. Stable sort (B) adds overhead to maintain relative order, and sequential execution (E) eliminates parallelism benefits.

Keep practicing — related questions