Stored Procedure Transformation in Informatica

Go to Transformation tab and select import stored procedure

Give username and password credentials and click on connect.

Stored Procedure Transformation in Informatica

Search for the procedure which you looking to import from informatica, select the procedure and and give OK

Stored Procedure Transformation in Informatica

Link with the output port

Stored Procedure Transformation in Informatica

You have successfully imported store procedure in informatica

Stored procedure transformation in informatica is very easy to use instead of using procedure in source qualifier tranformation

Author

Nagaraju M

Datawarehouse Architect