Stored Procedure Transformation

Explain about Stored Procedure Transformation

Stored Procedure transformation is a passive transformation which is used to import Stored Procedure from database
A Stored Procedure should exist in the database before using the Stored Procedure in the mapping

Set the following properties to define Stored Procedure transformation

1. Normal: This the default property set for the Stored Procedure transformation, it allows you to pass record by record to mapping during session execution

2. Source preload: A stored procedure executes before session reads the data from the source

3. Source postload: A stored procedure executes after session reads the data from the source

4. Target preload : A stored procedure executes before session loads the data into the target

5. Target postload : A stored procedure executes after session loads the data into the target

There are two types of stored procedures

1. Connected Stored procedure
2. Unconnected Stored procedure