unconnected stored procedure urgent ?

[vikind]

can anyone tell if this is possible

1. is it possible to have an unconnected stored procedure without any input parameters. but has output parameter
whats the alternative to this ?. should i just declare an dummy input variable in my stored procedure (database)
just for taking input from the mapping even though i will not use the input variable ?

2. does informatica allow unconnected stored procedures without input and output parameters. I have a procedure in SQL server
which does not have input and output parameters(for updating after session is complete) how can i use it in my mapping.

 

[ArtieChoke]

Not sure about 1, but for 2, if all you want is to run an SP after everything is done, check out the post-session SQL option in the source and target objects or the session object.

"I think we're all Bozos on this bus!" - Firesign Theatre