Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

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?

Cause
Solution
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
Database:
Operating System:
Other Software:

Reference
PowerCenter Transformation Guide > "SQL Transformation" > "Script Mode"
Attachments
Last Modified Date:3/10/2010 12:49 PMID:101152
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)