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: Change the execution order of unconnected Stored Procedure transformations in a PowerCenter mapping
Problem Description

When the Execution Order attribute is grayed out in the Stored Procedure Transformation properties, how to change the execution order of unconnected (Source Pre-load or Source Post Load, Target Pre Load or Target Post Load) Stored Procedure Transformations in a mapping?

Cause
Solution

To change the execution order of the Stored Procedure Transformations in a mapping, do the following:

  1. Go to Mappings > Stored Procedures Plan.

  2. In the Stored Procedure Execution Plan window select the type of Stored Procedure (Target Post Load, Source Pre Read, etc.).

  3. Highlight the Stored Procedure Transformation name.

  4. Use the up and down arrows on the right side in that window to move the Stored Procedure to the desired location.

     

The Execution Order number of each Stored Procedure can be verified under the Properties tab:

 

More Information
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter
Database:
Operating System:
Other Software:

Reference
PowerCenter Transformation Guide > "Stored Procedure Transformation" > "Configuring an Unconnected Transformation"
Attachments
Last Modified Date:1/21/2016 12:32 AMID:10440
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)