Stored procedure Transformation is passive transformation. It can be used both connected and unconnected mode. It contain a pre-compiled collection of PL-SQL statements. The stored procedures in the database are executed using the Execute or Call statemen