Multiple choice technology databases

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

  1. Constraints,Derivations,Stage variables

  2. Derivations,Constraints,Stage variables

  3. Stage variables,Derivations,Constraints

  4. Any of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In a DataStage Transformer stage, the execution order is: 1) Stage Variables (computed first), 2) Derivations (use stage variables), 3) Constraints (use both stage variables and derivations for filtering). This order ensures that derived values and constraints can reference previously computed stage variables.

Keep practicing — related questions