Multiple choice technology

In Sequence generator CURRVAL is NEXTVAL

  1. minus by value

  2. increment by value

  3. same as NEXTVAL

  4. None
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

In Sequence Generator transformation, CURRVAL is the NEXTVAL incremented by the configured value (increment by value). When NEXTVAL is called, it returns the current value and then increments by the specified increment value. CURRVAL then returns this incremented value. For example, if NEXTVAL returns 100 with an increment of 1, CURRVAL would be 101. This allows you to access both the value used and the next value in the sequence.

Keep practicing — related questions