Use the Standard mapping specification template to create a mapping specification for a single mapping or multiple mappings. The Standard mapping specification template contains mappings configured on multiple Excel worksheets. Mapping specifications based on this template can contain sources, targets, and Joiner, Filter, Expression, Lookup, Aggregator, and Java transformations. Use the Repository Manager to import the mapping specification and create the corresponding PowerCenter objects.
To create a mapping specification based on the Standard mapping specification template, complete the following steps:
Copy and rename the template.
Configure sources and targets on the Models worksheet.
Optionally, configure packages.
Optionally, configure domains and enumerations.
Optionally, configure rules.
Configure mappings.
Configure transformations.
Validate the mapping specification.
Before you create a mapping specification, install the Excel add-in included with Mapping Analyst for Excel. For more information about the Excel Add-in, see
Excel Add-In .