IBM
P2090-045 · Question #55
Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is…
The correct answer is A. If the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays. See the full explanation below for the reasoning.
Question
Consider a Parallel Job including a Join Stage with HASH partitioning algorithm followed by an Aggregator stage. Which of the following statements about the Aggregator stage partition algorithm is correct?about the Aggregator stage? partition algorithm is correct?
Options
- AIf the Aggregator groups on the same key column(s) as Join, SAME ensures groups of rows stays
- BIf the Aggregator groups on different key column(s) from Join, SAME ensures groups of rows stay
- CIf the Aggregator groups on the same key column(s) as Join, repartitioning must be done in order
- DROUND ROBIN ensures correct results
How the community answered
(32 responses)- A69% (22)
- B19% (6)
- C3% (1)
- D9% (3)
Community Discussion
No community discussion yet for this question.