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 sorting overhead and memory usage. Minimizing the number of sorts eliminates redundant processing steps. Adjusting the 'Restrict Memory Usage' option can prevent memory overflow and improve performance by managing memory allocation more efficiently. The stable-sort option (B) maintains order but doesn't improve performance, and sequential execution (E) reduces parallelism benefits.

Keep practicing — related questions