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

Field metadata

Field metadata

You can view and edit field metadata such as the type, precision, and scale for parameterized source and lookup objects with certain connection types.
To view and edit field metadata, use the
Edit Types
option on the appropriate page of the
mapping
task wizard. You configure source field metadata on the
Sources
page and lookup field metadata on the
Input Parameters
page.
If you edit field metadata in the task and the field metadata changes after the task is saved,
Data Integration
uses the updated metadata. Typically, the is the desired behavior. However, if the task uses a flat file connection and you want to retain the metadata used at design time, enable the
Retain existing fields at runtime option
.
You can't update field metadata in mapping tasks that are based on mappings in SQL ELT mode.
To see if a connector supports field metadata configuration, see the help for the appropriate connector.

0 COMMENTS

We’d like to hear from you!