PrepAway - Latest Free Exam Questions & Answers

Which three actions can improve sort performance in a DataStage job?

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

PrepAway - Latest Free Exam Questions & Answers

A.
Specify only the key columns which are necessary.

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

C.
Adjust the “Restrict Memory Usage” option in the Sort stage.

D.
Run the job sequentially so that only one sort process is invoked.

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

Explanation:


Leave a Reply