Transformations

Back Next

Invoking a stored procedure before or after a mapping run

You can configure an unconnected SQL transformation to process a stored procedure before or after a mapping run.

Data Integration

invokes the stored procedure at the specified time. You do not need to call the stored procedure with an :SP expression. You can configure the stored procedure to run before or after the mapping receives data from the source, or before or after the mapping loads data to the target.

You can configure the following stored procedure types:

Source Pre-load. The stored procedure runs before the mapping retrieves data from the source.

Source Post-load. The stored procedure runs after the mapping retrieves data from the source.

Target Pre-load. The stored procedure runs before the mapping sends data to the target.

Target Post-load. The stored procedure runs after the mapping sends data to the target.

On the

Advanced

tab, configure the stored procedure type and enter the call text for the stored procedure. The call text is the name of the stored procedure followed by any applicable input parameters in parentheses. If there are no input parameters, you must include an empty pair of parentheses. Do not include the SQL statement EXEC or use the :SP keyword.

For example, to call the stored procedure Drop_Table, enter the following call text:

Drop_Table()

To pass a string input parameter, enter it without quotes. If the string has spaces in it, enclose the parameter in double quotes. For example, if the stored procedure Drop_Table requires a table name as an input parameter, enter the following call text:

Drop_Table(Customer_list)

Rename Saved Search

Table of Contents

Transformations

Transformations

Invoking a stored procedure before or after a mapping run

Invoking a stored procedure before or after a mapping run