Multiple choice technology

Which of the following is strictly active/connected transformation?

  1. Lookup

  2. Expression

  3. Stored Procedure

  4. Transaction Control
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Transaction Control transformation is strictly an active/connected transformation - it must be connected to the data flow and cannot be used unconnected. It generates transaction control events (commit, rollback) based on conditions and changes the transaction boundary. In contrast, Lookup can be connected or unconnected, Expression is passive and connected, Stored Procedure can be connected or unconnected.

Keep practicing — related questions