Multiple choice technology databases

Which statement is true regarding sequence generator?

  1. It is having two ports nextval and currval

  2. We can add ports in it

  3. It is active and connected

  4. All of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The Sequence Generator transformation has exactly two ports: NEXTVAL (generates the next sequence value) and CURRVAL (returns the current sequence value). These are the only ports available and you cannot add custom ports to this transformation. It is a passive transformation and not connected to the data flow directly.

Keep practicing — related questions