Can we use procedural logic inside Infromatica? If yes how , if now how can we use external procedural logic in informatica?

Interview Candidate
Jul 14th, 2005
2
2933

First
Prev
Next
Last

Showing Answers 1 - 2 of 2 Answers

rajesh

Jul 13th, 2005

We can use External Procedure Transformation to use external procedures. Both COM and Informatica Procedures are supported using External procedure Transformation

Abhijit Jagtap

Jul 12th, 2007

You can Oracle PL/SQL stored procedure from Informatica using the STORED PROCEDURE Transformation. But it needs ODBC connection. You can pass the parameters to the stored procedure through a mapping. There are two ways :-

1. Stand alone
2. in the mapping flow.