Database Reference
In-Depth Information
The Stored Procedure transformation
It stores procedure database components. Informatica uses the stored procedure in a man-
ner that is similar to database tables. Stored procedures are sets of SQL instructions that re-
quire a certain set of input values, and in turn the stored procedure returns output values.
This way, you either import or create database tables and import or create the stored pro-
cedure in the mapping. To use the stored procedure in mapping, the stored procedure
should exist in the database.
Similar to Lookup transformations, stored procedures can also be connected or unconnec-
ted transformations in Informatica. When you use a connected stored procedure, you pass
the value to stored procedures through links. When you use an unconnected stored proced-
ure, you pass the value using the :SP function.
Search WWH ::




Custom Search