Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Print Bookmark Alert me when this article is updated


FAQ: Why is the "Is Active" option set for a SQL transformation created using script mode?
Problem Description

In a SQL transformation configured to run in script mode the Is active property appears as enabled. 
A SQL transformation created in script mode should be a passive transformation. 
Why is the Is active property enabled?

Even though the transformation is displayed as active in the Designer, it behaves as a passive transformation.
The transformation returns one row for each input row as it should as a passive transformation.
More Information
Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version: PowerCenter 8.1.1; PowerCenter 8.5; PowerCenter 8.5.1; PowerCenter 8.6; PowerCenter 8.6.1; PowerCenter 9.0
Operating System:
Other Software:

PowerCenter Transformation Guide > "SQL Transformation" > "Script Mode"
Last Modified Date:3/10/2010 12:49 PMID:101152
People who viewed this also viewed


Did this KB document help you?

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