Multiple choice technology databases

What is the order of execution of constraints,derivation and stage variables in a transformer stage?

  1. Derivations,Stage variables,Constraints

  2. Stage variables,Constraints,Derivations

  3. Constraints,Stage variables,Derivations

  4. Constraints,Derivations,Stage variables

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

The correct execution order in a DataStage Transformer stage is: 1) Stage Variables are computed first, 2) Constraints are evaluated to determine if the row passes through, 3) Derivations are computed for output columns. This differs from question 165491 which asked about a different order.