Can Informatica's Stored Procedure Transformer process stored procedures that have multiple resultsets?

Question

I have a stored procedure that returns two resultsets. I know Informatica has a Stored Procedure Transformer, but I cannot find anywhere it is possible to handle a stored procedure that returns more than one resultset.

Is this an Informatica capability?

Answer 1

It's not possible, I'm afraid. Informatica will not be able to 'guess' what to do with each dataset. In general, whatever it is that you need to do with the results, e.g. if you need to:

• join them, or
• use just one of them in a particular mapping, or
• switch between them with every run,

I'd recommend to wrap this stored procedure with another one, that would perform the logic required and return the appropriate result set.