Multiple choice technology

Which two system variables/techniques must be used in a parallel Transformer derivation to generate a unique sequence of integers across partitions? (Choose two.)

  1. @INROWNUM+1

  2. @INROWNUM

  3. @PARTITIONNUM

  4. @NUMPARTITIONS

Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

To generate unique integers across partitions in DataStage, you need @PARTITIONNUM to identify which partition a row is in, and @NUMPARTITIONS to know the total number of partitions. These allow you to calculate offsets: @PARTITIONNUM + (@NUMPARTITIONS * @INROWNUM). @INROWNUM alone only provides row numbers within each partition, causing duplicates across partitions.