PR000041 practice question 14 of 15

An Unconnected Stored Procedure can run in the following fashions?(Choose all that apply) Choose 3 answers

Full set: 69 questions
Answer options
A: From an expression Correct answer
B: As a Post-Session SQL command Correct answer
C: As a Pre-Session SQL command Correct answer
D: As the only object In the mapping
Correct Answer:
A. From an expression; B. As a Post-Session SQL command; C. As a Pre-Session SQL command
Explanation

An Unconnected Stored Procedure in Informatica is not part of the primary data flow pipeline and is called on demand. It can be invoked from an expression within another transformation (e.g., Expression, Update Strategy) using the :SP syntax. This allows for row-level conditional execution. Additionally, stored procedures can be executed outside the mapping's data flow using session-level commands. A Pre-Session SQL command executes the procedure before the session reads source data, often for setup tasks. A Post-Session SQL command executes it after the session completes its data load, typically for cleanup or logging. These contexts are independent of the mapping's row-by-row processing, fitting the "unconnected" nature of the task.

Why Incorrect

D. As the only object In the mapping: A valid Informatica mapping requires a data flow path from at least one source to one target. An unconnected object cannot exist in isolation and constitute a valid, runnable mapping.

References

1. Informatica PowerCenter 10.5

Transformation Guide

Chapter 22: "Stored Procedure Transformation"

Section: "Calling an Unconnected Stored Procedure".

Quote/Paraphrase: This section explicitly states

"To call an unconnected Stored Procedure transformation

use the :SP.procname expression in another transformation

such as an Expression or Update Strategy transformation." This directly supports option A.

2. Informatica PowerCenter 10.5

Workflow Administration Guide

Chapter 11: "Session Properties Reference"

Section: "General Tab Attributes".

Quote/Paraphrase: Under the descriptions for "Pre-session SQL" and "Post-session SQL"

the documentation clarifies that you can enter any valid SQL command for the database type

which includes commands to execute stored procedures (e.g.

EXEC procedurename

CALL procedurename). This supports options B and C.

3. Informatica PowerCenter 10.5

Designer Guide

Chapter 8: "Mappings"

Section: "Mapping and Mapplet Validity".

Quote/Paraphrase: The guide outlines the rules for a valid mapping

which include having a source qualifier connected to a source definition and a path to a target instance. An unconnected transformation by itself does not satisfy these rules

making option D incorrect.

Scroll to Top