Table of Contents

Search

  1. Preface
  2. Understanding Mapping Analyst for Excel
  3. Standard Mapping Specification Template
  4. Models Worksheet
  5. Packages Worksheet
  6. Domains and Enumerations Worksheets
  7. Mappings Worksheet
  8. Joins, Lookups, and Filters Worksheets
  9. Rules Worksheet
  10. Importing and Exporting Mapping Specifications

Mapping Analyst for Excel Guide

Mapping Analyst for Excel Guide

Standard Mapping Specification Template Overview

Standard Mapping Specification Template Overview

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:
  1. Copy and rename the template.
  2. Configure sources and targets on the Models worksheet.
  3. Optionally, configure packages.
  4. Optionally, configure domains and enumerations.
  5. Optionally, configure rules.
  6. Configure mappings.
  7. Configure transformations.
  8. 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 .

0 COMMENTS

We’d like to hear from you!