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

Creating a Mapping Specification

Creating a Mapping Specification

Create a mapping specification as a container for the business logic that transforms and moves data from source to target. You can choose to create a mapping specification from the
New
menu or from the
New Assets
panel in the
Design
workspace.
Before you create a mapping specification, verify that the sources you want to use exist in a project.
  1. From the
    New Assets
    panel in the
    Design
    workspace, click
    Mapping Specification
    .
    The
    New Mapping Specification
    wizard appears.
  2. Enter a unique name and an optional description.
  3. Select the project or folder where you want to create the mapping specification.
  4. Click
    Next
    .
  5. On the
    Sources
    panel, click the
    Add
    icon.
    The
    Add Source Object
    wizard appears.
  6. On the
    Source Object
    panel, select a source or multiple sources.
  7. Optionally, select a source and click
    Data Preview
    to preview the source data.
  8. Optionally, select a source and click
    Properties
    to view the source properties.
  9. Click
    OK
    , and then click
    Next
    .
  10. If you selected multiple sources, click the
    New Join
    icon to create a join and select the edit options to configure the join.
  11. Click
    OK
    , and then click
    Next
    .
  12. Choose to use a virtual target or a target from the
    Target Object
    panel.
    • Use a virtual target if you do not know the structure of the target data object.
    • Use a target from the
      Target Object
      panel if you know the structure of the data object. If you load the mapping specification results to a table, the structure of this target must match the structure of the target table.
  13. Optionally, select a target and click
    Data Preview
    to preview the target data.
  14. Optionally, select a target and click
    Properties
    to view the target properties.
  15. Click
    Finish
    .

0 COMMENTS

We’d like to hear from you!