Stored Procedure Transformation

Is it possible to call an unconnected stored procedure and make the call
text, or any portion of it, a mapping variable?

Thank you,

Pat

********************************************** ******************************
This message is for the designated recipient only and may contain privileged
or confidential information. If you have received it in error, please
notify the sender immediately and delete the original. Any other use of the
E-Mail by you is prohibited.
********************************************** ******************************

I have 2 stored procedures transformation(Pre load and post load). I have 7 target tables. I used Stored procedure transformation when there was 1 target and used the call text in the stored procedure with following syntax: stored procedure name(schema name, table name).

How do I do that when there are more than 1 targets. Should I use a stored procedure transformation for each of the targets. Or is there any syntax like

Ya, sure just you have to import the stored proc (from TRANSFROMATION
MENU IN DESIGNER). This will walk you through the process of creating
the proc and setting the i/p and o/p ports corresponding to ur i/p and
o/p parameters.
Let me know if u need some more info.

Hello everyone,
I am back with a new problem.
And by the way,I would like to thank everyone who have answered all my queries to date.Thank u all!!

I have a stored procedure that returns 2000 rows all of which have to be inserted in a target table.My question is,can Informatica handle this,as the procedure runs just once ,and all the rows are output at that time?
If possible,what is the right way of doing this.
thank u again.

Hi
I am facing an issue like stored transformation is update statement is updating only few records and the remaining records are not updated with values.When itry to execute the query seperately in TOAD its giving out he values.

I believe you are not going to use Unconnected SP...because they return only one Output (as far as I know) ...but if you are gonna use Connected SP then just use a SP TRF in informatica mapping ...then Informatica will take care of input and output ports in it as per things defined in your actual SP programme.
Hope that solves your problem.