Table of Contents

Search

  1. Preface
  2. The Transformation Language
  3. Constants
  4. Operators
  5. Variables
  6. Dates
  7. Functions
  8. Creating Custom Functions
  9. Custom Function API Reference

Transformation Language Reference

Transformation Language Reference

Aggregate Functions and Nulls

Aggregate Functions and Nulls

When you configure the
PowerCenter Integration Service
, you can choose how you want to handle null values in aggregate functions. You can have the
PowerCenter Integration Service
treat null values in aggregate functions as NULL or 0.
By default, the
PowerCenter Integration Service
treats null values as NULL in aggregate functions. If you pass an entire port or group of null values to the COUNT function, the function returns 0. If you pass an entire port or group of null values to any other aggregate function, the function returns NULL. You can optionally configure the
PowerCenter Integration Service
if you pass an entire port of null values to an aggregate function to return 0.

0 COMMENTS

We’d like to hear from you!