What is the diff b/w Stored Proc (DB level) & Stored proc trans (INFORMATICA level) ?again why should we use SP trans ?

Interview Candidate
May 17th, 2006
2
1706

Showing Answers 1 - 2 of 2 Answers

prasanth

May 17th, 2006

If you need to call a stored procedure inside your mapping to pass a value to the SP and return or just return values to your mapping you need to use a SP transformation.

windows
Profile Answers by windows Questions by windows

May 17th, 2006

First of all stored procedures (at DB level) are series of SQL statement. And those are stored and compiled at the server side.In the Informatica it is a transformation that uses same stored procedures which are stored in the database. Stored procedures are used to automate time-consuming tasks that are too complicated for standard SQL statements.if you don't want to use the stored procedure then you have to create expression transformation and do all the coding in it.