Stored Procedure transformation
Stored Procedure is a database component. Informatica uses the Stored Procedure similar to database tables. Stored Procedures are a set of SQL instructions that require a certain set of input values and return an output value. You can import or create the Stored Procedure in mapping the way you either import or create database tables. To use Stored Procedure in mapping, the stored procedure should exist in the database.
Similar to Lookup transformation, Stored Procedure can also be connected or unconnected transformation in Informatica. When you use connected Stored Procedure, you pass the value to Stored Procedure through links. When you use unconnected Stored Procedure, you pass the value using the :SP
function.
Importing Stored Procedure transformation
Importing the Stored Procedure is similar to importing the database tables in Informatica. We have seen earlier the process of importing database tables. Before you import the Stored Procedure, make sure the...