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

Creating a field expression

Creating a field expression

Create a field expression in a task wizard.
  1. On the
    Field Mappings
    or
    Input Parameters
    page, select the target field for which you want to add an expression.
  2. Perform one of the following actions based on your task type:
    • Click
      Add or Edit Expression
      .
    • Click
      Actions
      >
      Edit Expression
      , or click the field name.
    By default, the
    Field Expression
    dialog box shows the source field as the expression, which indicates that the target contains the same value as the source.
  3. Enter the new field expression.
    To include source fields and system variables in the expression, you can select them from the
    Source Fields
    and
    System Variables
    tabs to insert them into the expression or you can add them to the expression manually.
  4. Click
    Validate Mapping
    to validate the field mappings.
  5. Click
    Save
    .

0 COMMENTS

We’d like to hear from you!