Creating mapping specifications

You create mapping specifications that consists of source-to-target mappings. You can use any existing, shared metadata column or any term from the business glossary as sources or targets. You can also create candidate columns and terms within specifications.

Before you begin

You must create a project or be authorized to work within a project before you can work with specifications.

About this task

Mapping specifications are used to document business requirements. A mapping specification contains mappings. Create a specification and then create source-to-target mappings by using the mapping editor. Each mapping can consist of more than one source and more than one target.

You can refine mappings by using transformation rules. Transformations specified for a mapping apply to all the sources and the output of the transformations apply to all the targets. If you want to use several different transformations, but with the same set of sources within a mapping, then you must create multiple mappings with different transformations that use the same set of sources.

You can then generate reports. Or, you can generate jobs that can be further modified and enhanced in the Designer client.

Procedure

Select a project in the Mapping Specifications list and, from the Task list, click New Mapping Specification.
Tip: If you cannot see Mapping Specifications, click the Mapping workspace. If you cannot see the Task list, click on the expansion arrow to the right of the Mapping Specifications list.
Complete the fields.
- The name can contain any character and can be 1 to 255 characters in length.
- The status you provide is shown in the Mapping Specifications list. Use this field to indicate the work stage of the mapping specification.
- You can define a business owner of a mapping specification. This owner can be different from the creator or the person that modifies the specification. You do not restrict access by providing an owner name.
You can put a document or file hyperlink in either the Description field or Annotation field to better document a specification, a project, or a mapping. Links can be enabled simply by typing the link into the field. You can also drag files from the desktop or web browser to quickly create a link. Supported link types are https://, http://, file://, and ftp://. Clicking a link from the description field launches an external browser.
Click Save.
Click the task Column Mappings to work in the Mapping Editor.