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

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?
Cause
Solution

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

Reference

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

Attachments
Last Modified Date:12/13/2010 2:07 PMID:32053
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)