Multiple choice technology

Which of the following are true about an unconnected stored procedure transformation?

  1. The input/output parameters in the expression must match the input/output ports in the Stored Procedure transformation

  2. A single output parameter is returned using the variable PROC_RESULT

  3. The same instance of a Stored Procedure transformation cannot run in both connected and unconnected mode in a mapping

  4. We cannot have multiple levels of nested stored procedures
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

Unconnected stored procedures require: input/output parameters in expressions to match the transformation ports exactly (A), use PROC_RESULT variable to return a single output parameter (B), and cannot mix connected/unconnected modes for the same transformation instance in a mapping (C). Nested stored procedures are allowed at multiple levels.

Keep practicing — related questions