Database Reference
In-Depth Information
Using Stored Procedure transformations in the
mapping
As mentioned, Stored Procedure transformations can be connected or unconnected. Similar
to Lookup transformations, you can configure connected or unconnected Stored Procedure
transformations.
Connected Stored Procedure transformations
A connected Stored Procedure transformation is connected in the mapping with the links.
The connected Stored Procedure transformation receives data in the input port and sends
the data out using output ports. A sample mapping showing the connected Stored Proced-
ure transformation is shown in the following screenshot:
Unconnected Stored Procedure transformations
An unconnected Stored Procedure transformation is not connected to any other source, tar-
get, or transformation by links. The unconnected Stored Procedure transformation is called
by another transformation using the
:SP
function. It works in a manner similar to an un-
connected Lookup transformation, which is called using the
:LKP
function.
A sample mapping using the unconnected Stored Procedure transformation is shown in the
following screenshot:
