What is the way to execute PL/SQL script using Informatica mapping?
What is the way to execute PL/SQL script using Informatica mapping?
- Stored procedures are used to have the transformation of the procedures to be placed in the application.
- The execution can be used to provide PL/SQL script that provides the mapping to be done as well with the application.
- The procedure name is specified during the Stored procedure transformation using the script mentioned.
- The session is executed and saved by the session that will call up the procedure using the scripts.
- The mapping is to be done for the procedures so that connectivity can be done according to the use.