Multiple choice technology databases

What is the specific partitioning technique should be used for join stage?

  1. auto

  2. hash

  3. entire

  4. same

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The Join stage in DataStage requires the input datasets to be partitioned using the hash partitioning technique on the join key columns, and sorted, so that matching keys from different datasets reside in the same partition.