Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Aggregate functions

Aggregate functions

You can use aggregate functions for template parameters associated with an Aggregator object.
Aggregate functions display in the
Field Expression
dialog box when you configure the template parameter display options in the Visio template to allow aggregate functions. You can use the following aggregate functions:
  • AVG
  • COUNT
  • FIRST
  • LAST
  • MAX (Date)
  • MAX (Number)
  • MAX (String)
  • MEDIAN
  • MIN (Date)
  • MIN (Number)
  • MIN (String)
  • PERCENTILE
  • STDDEV
  • SUM
  • VARIANCE

0 COMMENTS

We’d like to hear from you!