Table of Contents

Search

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

Transformation Language Reference

Transformation Language Reference

Numeric Functions

Numeric Functions

The transformation language includes the following numeric functions:
  • ABS
  • CEIL
  • CONV
  • CUME
  • EXP
  • FLOOR
  • LN
  • LOG
  • MAX
  • MIN
  • MOD
  • MOVINGAVG
  • MOVINGSUM
  • POWER
  • RAND
  • ROUND
  • SIGN
  • SQRT
  • TRUNC