PR000041 practice question 4 of 15
Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers
Full set: 69 questionsThe Stored Procedure transformation in Informatica PowerCenter is designed to call a database stored procedure or function. It uses specific port types to interact with the procedure. Input ports pass data from the mapping pipeline to the procedure's input parameters. Output ports receive values from the procedure's output parameters back into the pipeline. A Return port is a special output port used to capture the return value when the stored procedure is a function.
C. Variable: Variable ports are used for intermediate calculations within a single row and are not a feature of the Stored Procedure transformation. They are found in transformations like Expression and Aggregator.
1. Informatica PowerCenter 10.5 - Transformation Guide
Chapter 23: Stored Procedure Transformation
"Configuring Stored Procedure Transformation Ports"
Page 499.
The documentation states: "The Stored Procedure transformation can have input
output
and input/output ports. It can also have one return port to capture the return value from a stored function." This explicitly lists Input
Output
and Return as valid port types.
2. Informatica PowerCenter 10.2 - Transformation Guide
Chapter 22: Stored Procedure Transformation
"Ports in a Stored Procedure Transformation"
Page 473.
This guide details the port configuration: "On the Ports tab
you create a port for each stored procedure parameter and for the return value
if any... You can configure the following types of ports in a Stored Procedure transformation: Input
Output
Input/Output
Return." This confirms the validity of options A
B
and D.
Question breakdown
Key idea: Stored Procedure transformation ports mirror the procedure's parameters (input, output, input/output) plus an optional return value port, and they do not support variable ports.
How to reach the answer
- Remember that each port in this transformation maps to a database procedure parameter or to its return value.
- Input ports send values into the procedure; output ports bring values back into the pipeline.
- A return port captures a function's return value, and only one is allowed.
- Variable ports are for intermediate calculations in transformations like Expression; they have no matching database parameter, so they are excluded.
Each option
Common trap: Variable ports appear in many transformations, so candidates assume they are universal; the Stored Procedure transformation does not offer them.
In practice: When importing a procedure, the Designer builds ports from the parameter list; developers then flag the return port for functions or for status codes used in error handling.
Remember: Stored Procedure ports are Input, Output, Input/Output, and one Return, never Variable.
Drafted with AI assistance and checked against the answer key.
Keep practicing
Take the free PR000041 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other PR000041 practice questions
- Question 2What function could be used to exchange 'i' with 'I' in the COMPANY port given the follow…
- Question 3Which of the following statements is correct on workflow events?
- Question 5Which is the correct priority of assigning a mapping variable?
- Question 6Two pipelines (A & B) are entering a Joiner transformation with each having a record size…
- Question 7Referring to the Sequence Generator transformation, which statement is correct and true?
- Question 8Which statement on workflows is correct?
