Mapping Analyst for Excel Guide

10.5
- 10.5.7
- 10.5.6
- 10.4.0

Back Next

Exporting Mappings

Use the Repository Manager to export objects from the PowerCenter repository to a mapping specification. You can export source and target definitions, or you can export a valid mapping containing Filter, Joiner, Lookup, Aggregator, and Expression transformations.

The PowerCenter Repository Service does not export Java transformations to the Rules worksheet of the mapping specification.

The PowerCenter Repository Service exports transformations Mapping Analyst for Excel supports. If you export a mapping with other transformations, target definitions might not contain all ports in the mapping specification.

In the Repository Manager, open a folder that contains the repository objects that you want to export.

In the Navigator, select the mapping or set of sources or targets that you want to export.

Click

Repository

Export Metadata

The Tool Selection page appears.

For Target Tool, select Microsoft Office Excel and click

The Microsoft Office Excel Options page appears.

Enter the options.

The following table describes the options that you need to enter:

Microsoft Excel Option	Description
File	Name of the mapping specification for the exported metadata. Click the Value field to find and select the mapping specification that you want to use. Or, enter a file name with an .xlsx extension for the wizard to create. You can export metadata to the same file multiple times. When you export to a mapping specification that contains existing data, the PowerCenter Repository Service writes information to empty cells or overwrites existing data.
Format	Name of the mapping specification template that you want to use. Select Standard.

Microsoft Excel Option

Description

File

Name of the mapping specification for the exported metadata.

Click the Value field to find and select the mapping specification that you want to use. Or, enter a file name with an .xlsx extension for the wizard to create.

You can export metadata to the same file multiple times. When you export to a mapping specification that contains existing data, the PowerCenter Repository Service writes information to empty cells or overwrites existing data.

Format

Name of the mapping specification template that you want to use. Select Standard.

Click

Export

In the Export Results dialog box, a message appears if the export is successful. Error messages display when the export is not successful.

Click

Show Details

to view log events. You can also click

Save Log

to save the log events to a log file.

Click

Finish