Mapping Analyst for Excel Guide

10.5
- 10.5.7
- 10.5.6
- 10.4.0

Back Next

Configuring the Models Worksheet

To configure the Models worksheet, enter the source and target metadata in one of the following ways:

A business analyst types the source and target metadata into the Models worksheet.

If the source and target metadata exists in the PowerCenter repository, a PowerCenter developer adds the source and target definitions to a mapping, but does not connect the ports. The developer then exports the mapping to a mapping specification. The business analyst opens the mapping specification in Microsoft Excel and views the Models worksheet populated with the source and target metadata. The business analyst does not edit the source and target metadata on the Models worksheet.

To type source and target metadata into the Models worksheet:

Click

Metadata

Show and Hide

Min

to view the required properties.

Enter the name of the model containing the source or target metadata.

Select the database type for the model.

Enter the name of the source or target schema.

Enter the name of the source or target table or file.

Enter the name of each column in the table or file.

Select the datatype for each column from the list of datatypes valid for the database type.

To enter a user-defined domain configured on the Domains worksheet, enter the name of the domain in the Datatype Name column.

Enter the length and scale of each column.

If you selected a user-defined domain for the column datatype, the PowerCenter Repository Service assigns the datatype, length, and scale defined on the Domains worksheet to the column.

To enter optional properties, click

Metadata

Show and Hide

Max

Models Worksheet

Models Worksheet Properties

Domains and Enumerations Worksheets Overview

Download Guide

Watch

Comments

Communities

Knowledge Base