Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(3 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Pass a PowerCenter mapping variable to a Stored Procedure transformation
Solution

To pass mapping variable to a Stored Procedure transformation do the following:

Connected Stored Procedure

The parameters that are passed to a connected Stored Procedure have to be linked from another transformation.
Follow the steps below to pass mapping variable to a connected Stored Procedure transformation:

  1. Create an Expression transformation.

  2. Create an output port in the Expression transformation with the following expression:

    $$mapping_variable

    This sets the value of this output port to the mapping variable.

  3. Link this output port to the Stored Procedure transformation.

Unconnected Stored Procedure

For unconnected Stored Procedure transformations you can use the mapping variable in the expression calling the stored procedure.
Follow the steps below to pass mapping variable to a unconnected Stored Procedure transformation:

  1. Create an Expression transformation.

  2. Add an output port to the Expression transformation with the following expression:

    :SP.GET_NAME_FROM_ID($$mapping_variable, PROC_RESULT)

More Information
Reference
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:4/16/2010 4:36 PMID:18430
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)