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 Specification Export to PowerCenter

Mapping Specification Export to PowerCenter

Export a mapping specification to PowerCenter to share the mapping specification logic with a PowerCenter developer. When you export a mapping specification to PowerCenter you can take advantage of capabilities that are exclusive to PowerCenter such as partitioning, web services, and recovery.
When you export a mapping specification to PowerCenter, you can choose to use the target in the mapping specification or select a target that exists in the Model repository.
If you do not select a target in the mapping specification during export, the Analyst tool exports the mapping specification as a mapplet to PowerCenter. The PowerCenter developer can use this mapplet as a source in a mapping and select a target. The developer can create a session, workflow, and connection objects. The developer can run the workflow.
If you select a target in the Model repository during export, the Analyst tool exports the mapping specification as a mapping to PowerCenter. The Analyst tool export process creates a non-reusable session for this mapping in a workflow. Before the developer runs the workflow, the developer must create the connection objects for the sources and the target in the mapping.
When you export a mapping specification to PowerCenter, you can choose to the following export options:
Export to a PowerCenter Repository
You must specify the PowerCenter repository connection properties and the folder in the PowerCenter repository where you want to export the mapping specification. The connection information for sources and target are not exported.
Export to an XML File
If you do not have permissions to export the mapping specification to a PowerCenter repository, you can choose to export the mapping specification to an XML file. You can download the XML file and share it with a PowerCenter developer. The developer can import the XML file into the PowerCenter repository and use the mapping specification logic as a mapplet or mapping.
In the PowerCenter Designer, the mapping specification objects appear in the appropriate node in the folder. For example, the mapping specification target appears in the Targets node.
PowerCenter developers can view descriptions about mapping specification objects after the mapping specification logic is exported to PowerCenter. Viewing descriptions about mapping specification objects enables PowerCenter developers to understand the logical flow of a mapping specification. In PowerCenter, these descriptions appear in the transformation properties or in the descriptions of the ports in a transformation.

0 COMMENTS

We’d like to hear from you!