August 2017
Beginner to intermediate
426 pages
9h 36m
English
An unconnected Stored Procedure transformation is not connected to any other source, target, or transformation by links. Unconnected Stored Procedure transformation is called by another transformation using the :SP function. It works similar to unconnected Lookup transformation, which is called using the :LKP function. A sample mapping using unconnected Stored Procedure transformation is shown here:

We have used Expression transformation to call the Stored Procedure. The function that is used to call Stored Procedure is this:
:SP.SP_CONN(SALARY_TOTAL,PROC_RESULT).
Follow similar steps to create ...
Read now
Unlock full access