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

Transformation language components for expressions

Transformation language components for expressions

The transformation language includes the following components to create simple or complex expressions:
  • Fields. Use the name of a source field to refer to the value of the field.
  • Literals. Use numeric or string literals to refer to specific values.
  • Functions. Use these SQL-like functions to change data in a task.
  • Operators. Use transformation operators to create expressions to perform mathematical computations, combine data, or compare data.
  • Constants. Use the predefined constants to reference values that remain constant, such as TRUE.
In mappings in SQL ELT mode, you use your cloud data warehouse's native expression components to create expressions. You don't use the Informatica transformation language to create expressions.

0 COMMENTS

We’d like to hear from you!