🎴 Flashcard Mode
SAP MII and ETL Technology Quiz
Card1 / 20
Mastered0
Review0
QuestionClick to flip
Which two system variables/techniques must be used in a parallel Transformer derivation to generate a unique sequence of integers across partitions? (Choose two.)
AnswerClick to flip back
A
@PARTITIONNUM
B
@NUMPARTITIONS
💡 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.