PR000041 practice question 4 of 15

Which port types are applicable to the Stored Procedure transformation?(Choose all that apply) Choose 3 answers

Choose your answer, then check it against the explanation and the full breakdown below.

Answer options

Correct Answer:

A, B, D

Explanation

The 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.

Why Incorrect

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.

References

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

and D.

Question 4 of 15

Question breakdown

Tests: Stored Procedure transformation configuration
Difficulty: Easy

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

ACorrect. Input ports pass pipeline values into the procedure's IN parameters.
BCorrect. Output ports receive values from the procedure's OUT parameters.
CIncorrect. Variable ports are unavailable here because there is no procedure parameter for them to bind to.
DCorrect. A single return port captures the return value of a stored function.

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.

Start the free practice test