IBM
C2090-303 · Question #68
A DataStage job uses an Inner Join to combine data from two source parallel datasets that were written to disk in sort order based on the join key columns. Which two methods could be used to…
The correct answer is B. Set the environment variable $APT_SORT_INSERTION_CHECK_ONLY. E. Add a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort. See the full explanation below for the reasoning.
Question
A DataStage job uses an Inner Join to combine data from two source parallel datasets that were written to disk in sort order based on the join key columns. Which two methods could be used to dramatically improve performance of this job? (Choose two.)
Options
- ADisable job monitoring.
- BSet the environment variable $APT_SORT_INSERTION_CHECK_ONLY.
- CUnset the Preserve Partitioning flag on the output of each parallel dataset.
- DExplicitly specify hash partitioning and sorting on each input to the Join stage.
- EAdd a parallel sort stage before each Join input, specifying the "Don't Sort, Previously Grouped" sort
How the community answered
(25 responses)- A16% (4)
- B72% (18)
- C4% (1)
- D8% (2)
Community Discussion
No community discussion yet for this question.