Mapping Analyst for Excel Guide

10.4.0
- 10.5.7
- 10.5.6
- 10.5

Back Next

Importing Mapping Specifications

Use the Repository Manager to import a mapping specification. You can import source and target definitions, or you can import an entire mapping. You can also import more than one mapping at a time if the mapping specification contains multiple mappings. Mappings do not have to be complete or valid.

The following table describes the PowerCenter objects that the PowerCenter Repository Service creates when you import a mapping specification based on the Standard mapping specification template:

Mapping Analyst for Excel Component	PowerCenter Repository Object
Source information.	Source definitions.
Filter expression to filter data from the pipeline.	Filter transformation.
Join expression to join two sources. To join more than two sources, you can enter multiple join expressions.	Joiner transformation.
Lookup expression to perform a lookup.	Connected Lookup transformation.
Aggregate data transformation expression.	Aggregator transformation.
Single row data transformation expression.	Expression transformation.
Rule.	Java transformation.
Target information.	Target definitions.
Additional comments or descriptions	Descriptions associated with transformations and source and target definitions. Provides additional notes to the PowerCenter developer.
User-defined properties.	Metadata extensions.

When you import a mapping specification, the PowerCenter Repository Service adds the transformations to the mapping in a specific order. After the source definition, the PowerCenter Repository Service adds the Joiner, Lookup, Filter, Expression, Java, and Aggregator transformations, and then the target definition. The PowerCenter developer can edit the mapping and change the order of the transformations.

After you import a mapping specification, review the imported objects. Most mappings imported from a mapping specification require editing before validation.

In the Repository Manager, open a folder and click

Repository

Import Metadata

The Tool Selection page appears.

In the Source Tool field, select Microsoft Office Excel and click

The Microsoft Office Excel Options page appears.

Click the Value field for the File option to find and select the mapping specification to import.

Click

The PowerCenter Options page appears.

Enter the options.

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

Option	Description
Export Objects	Objects that you want to import into the PowerCenter repository. Select one of the following options: Sources, targets, and mappings. Imports an entire mapping from the mapping specification. Use for mapping specifications that describe an entire mapping. Tables as sources. Imports all tables or files as sources. Tables as targets. Imports all tables or files as targets. Default is Tables as sources.
Database type	Database type of the source and target databases. Select a database type, Flat File, or select Auto Detect to allow PowerCenter to determine the database type from the mapping specification. Default is Auto Detect.
Database name	Database name for imported source tables. Overrides the source database name entered in the mapping specification. Optional.
Code page	Name of the PowerCenter Repository Service code page. Default is MS 1252.
Export metadata extensions	Import descriptions and comments as PowerCenter metadata extensions. Select one of the following options: True. Import descriptions and comments. False. Do not import descriptions and comments. Default is true.
Path to the Informatica installation	Path to the Informatica PowerCenter client binary files. For example, set the PowerCenter client installation to: C:\Informatica\PowerCenter <Version number> . Ensure that the path contains client and java folders. If this parameter is not specified when you import the rules worksheet for a Java transformation, then Mapping Analyst for Excel will not generate Java byte code for business rules.

Click

Use Defaults

to revert to default options.

Click

In the Import Results dialog box, a message appears if the export from the mapping specification is successful. Error messages appear 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 file.

Click

The Source Selection dialog box displays the sources or targets in the mapping specification with all objects selected by default.

Select the objects that you want to import and click

Finish

The PowerCenter Repository Service imports the metadata from the mapping specification.

If the import folder contains objects of the same name as those you are importing, the Conflict Resolution Wizard displays. For more information about the conflict, click

Compare Conflict

Otherwise for each conflicting object, select the object and choose one of the following resolutions:

Rename. Change the object name when importing it to the target folder.

Replace. Replace the existing object in the target folder.

Reuse. Use the existing object in the target folder.

Skip. Skip importing the object.

You can also apply the same resolution to all sources or to all conflicts.

Click

, and then click

to close the Conflict Resolution Wizard.

Importing and Exporting Mapping Specifications

Download Guide