Multiple choice technology

Stored Procedure Transformation is a________Transformation A)Passive B)Active C)Unconnected D)Connected

  1. A

  2. A,C,D

  3. B,C,D

  4. A,B,C,D
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Stored Procedure Transformation in Informatica is Passive (does not change the number of rows), Unconnected (can be called from other transformations using :SP syntax), and Connected (can be used directly in the data flow). It is NOT Active because it cannot increase or decrease row count. The combination A, C, D correctly describes all applicable characteristics.

Keep practicing — related questions