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 questionsAn 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.
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.
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.
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 4Which port types are applicable to the Stored Procedure transformation?(Choose all that a…
- 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?
