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


HOW TO: Control the handling of NULL values in a PowerCenter Aggregator transformation
Problem Description
Is there a way to treat the NULL values as zero in a PowerCenter Aggregator transformation?

To make the Aggregator return zero ("0") when all values of grouped by columns are Null do the following:

  1. Log in to the PowerCenter Administration Console.

  2. Select the Integration Service.

  3. Under Compatibility and Database Properties select "Yes" for AggregateTreatNullAsZero.

  4. Restart the Integration Service for the change to take effect.

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


PowerCenter Administrator Guide > "Creating and Configuring the Integration Service" > "Configuring the Integration Service Properties"

Last Modified Date:12/13/2010 2:07 PMID:32053
People who viewed this also viewed


Did this KB document help you?

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