Although the repository validates and saves the mapping, the PowerCenter Designer does not validate whether or not the Stored Procedure expression runs without an error.
If the stored procedure expression is not configured properly, the session will fail. When testing a mapping using a Stored Procedure, do the following:
Configure these session options on the Error Handling settings of the Config Object tab in the session properties.
What can we do to improve this information (2000 or fewer characters)