Table of Contents

Search

  1. Preface
  2. Introduction to Mapping Specifications
  3. Mapping Specification Configuration
  4. Mapping Specification Objects
  5. Mapping Specification Profiles
  6. Sharing Mapping Specification Logic

Mapping Specification Guide

Mapping Specification Guide

Mapping Source and Target Columns by Name or Position

Mapping Source and Target Columns by Name or Position

When you map source and target columns by column name, the Analyst tool ignores source and target prefixes and suffixes. When you map source and target columns by column position, the Analyst tool maps the first or last source column with the target column you select.
  1. From the
    Actions
    menu, click the
    Automap Columns
    icon.
    The
    Automap
    wizard appears.
  2. Choose to map columns in simple or advanced mode.
    • To map columns in the simple mode, select
      Simple
      .
    • To map columns in the advanced mode, select
      Advanced
      and choose to map columns by name or column position.
    In the Simple mode, the Analyst tool maps columns with the same name or position. In the Advanced mode, the Analyst tool maps columns based on either name or position.
  3. Optionally, on the
    Transformation and Target Columns
    panel, click
    Refresh
    to update the mapping specification with mapped columns, and click
    OK
    .
  4. Click
    Save
    .

0 COMMENTS

We’d like to hear from you!