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

Transformation Language Components

Transformation Language Components

The transformation language includes the following components to create simple or complex transformation expressions:
  • Functions.
    Over 100 SQL-like functions allow you to change data in a mapping.
  • Operators.
    Use transformation operators to create transformation expressions to perform mathematical computations, combine data, or compare data.
  • Constants.
    Use built-in constants to reference values that remain constant, such as TRUE.
  • Mapping parameters and variables.
    Create mapping parameters for use within a mapping or mapplet to reference values that remain constant throughout a session, such as a state sales tax rate. Create mapping variables in mapplets or mappings to write expressions referencing values that change from session to session.
  • Workflow variables.
    Create workflow variables for use within a workflow to write expressions referencing values that change from workflow to workflow.
  • Built-in and local variables.
    Use built-in variables to write expressions that reference values that vary, such as the system date. You can also create local variables in transformations.
  • Return values.
    You can also write expressions that include the return values Lookup transformations.