Mapping Specification Guide

10.4.0
- 10.5

Back Next

Properties Panel

View the properties for a mapping specification on the

Properties

panel. The

Properties

panel also appears as a panel on the bottom panel of the

Column Mapping

panel. The

Properties

panel also displays mapping specification properties in the

Where Used

Target Columns

, and

Rules

panels.

The following mapping specification properties appear on the

Properties

panel:

Name: Name of the mapping specification.
Type: Object type. Displays Mapping Specification for a mapping specification.
Description: Description of the mapping specification.
Location: Location of the project or folder that contains the mapping specification.
Created on: Date that the mapping specification was created.
Created by: Name of the user who created the mapping specification.
Source columns: Source tables used in the mapping specification.
Target columns copied from: Data object used to create the target columns.
Last modified on: Date that the mapping specification was last modified.
Last modified by: Name of the user who last modified the mapping specification.
Job Status: Displays the status of the load operation that loads the results of the mapping specification to the target.
Last loaded to target: Displays the date that the mapping specification results were last loaded to the target.
Last target loaded: Displays the last target that the mapping specification results were loaded to.
PowerCenter folder: Displays the folder in PowerCenter where the mapping specification was exported.
Target object: Type of target that the data in the mapping specification was loaded to.
Tags: Lists tags used in the mapping specification.
Virtual database: Virtual database name for the mapping specification exported as a virtual table.
Virtual table: Virtual table name for the mapping specification exported as a virtual table.
JDBC URL: JDBC URL for the mapping specification exported as a virtual table.
Last Loaded: Date the mapping specification logic was last exported as a virtual table.

The following mapping specification property appears on the

Where Used

panel:

Name: Lists the mapping specification name that is used as a source. Lists where objects in the mapping specification are used in other projects.

The following mapping specification properties appear on the

Target Columns

panel:

Target Name: Target column name.
Datatype: Target column datatype.
Precision: Target column precision.
Scale: Target column scale.
Nullable: Property for a relational database column that determines if the column can contain null values.
Key: Key column in the target.

The following mapping specification properties appear on the

Rules

panel:

Rules: Rule column name. Displays input and output column names.
Column: Rule column name.
Datatype: Rule column datatype.
Precision: Rule column precision.
Scale: Rule column scale.

Rename Saved Search

Table of Contents

Mapping Specification Guide

Mapping Specification Guide

Properties Panel

Properties Panel