The Lifeline of Informatica –Transformations - Learning Informatica PowerCenter 9.x - page 363

Importing Stored Procedure transformations
Importing the stored procedure is similar to importing the database tables in Informatica.
Earlier, we saw the process of importing database tables. Before you import the stored pro-
cedure, make sure the stored procedure is created and tested at the database level. Also,
make sure that you have valid credentials to connect to the database.
To import the stored procedure, open the mapping in Mapping Designer. Click on Trans-
formation and select the Import Stored Procedure… option, as shown in the following
screenshot:
Connect to the database credentials, click on the required procedure, and click on OK .