Tag: division

Quizzes (0) Questions (1)

Questions Related to division

Multiple choice datastage division

In Datastage 8.5, If division operation has to be performed in Transformer stage, What will be the output if Numerator is 1 and denominator is 0 ?

  1. Zero

  2. Infinity

  3. Null

  4. Job aborts
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In DataStage 8.5 Transformer stage, division by zero (1/0) returns Zero rather than aborting the job or returning infinity/null. This is a specific behavior in DataStage - many systems would throw an error or return NULL for division by zero, but DataStage handles it gracefully by returning zero. This behavior was changed in later versions.