Mapping editor properties

The Properties view displays the properties for the selected objects in the mapping editor.

While you are working with the mapping editor, you can see details of the currently selected objects in the Properties view. For any element in the mapping editor that is associated with a Properties view, right-click on the element and select Properties to open the focus to the Properties view. As you select elements in the mapping editor or the outline view, the Properties view changes to reflect those selections.

The content of the properties view changes according to the kind of selected object.
Source and Target objects
The Properties view of the Source and Target fields contains information about the elements, such as data type, default values, and comments. If you selected a table element in the Source or Target field, this Properties view has General, Columns, and Comments pages. If you selected a column element in the Source or Target field, then this Properties view has General, Type, and Comments pages.
Mapping or discovered mapping
The Properties view of a mapping object contains information about the sources, targets, and annotations of a mapping. An accepted mapping also contains a transformation. A discovered mapping also provides information about the results of the discover function. You can open the Expression Builder from the Properties view of an accepted mapping.
Mapping group
The Properties view of a mapping group object contains information about sources, targets, annotations, join conditions, filter conditions, and sort conditions of the selected mapping group. You can open the Expression Builder from this view.
The following table describes the information on each page of the Properties view.
Table 1. Properties view descriptions
Page name Description
General Describes the selected object with name and label. This is read-only.
Columns Displays the name of the table, the columns, and the metadata. This is read-only.
Type Displays the name of the table and details pertaining to the data type. This is read-only.
Comments Shows comments about the object. This is read-only.
Mapping Shows details about the sources and the targets and the data types of the columns and elements that participate in the mapping. You can open the Expression Builder from the Properties view unless this is a discovered mapping. You can also define or edit an expression in the available transformation field.
Annotation Shows the text that describes the name and value pairs that relate to the mapped elements. You can add an annotation to any mapping. Click the icon to display a table with columns of Name and Value. You can delete any name and value pairs that exist by clicking the delete icon. The X symbol is the delete icon. It allows you to delete the selected row. You can add an annotation by clicking the plus icon. The plus symbol is the edit icon. It allows you to modify the annotation.. You can edit an annotation by clicking into the text field.
Discover Relationships Shows information about the matching score, which is a confidence level of the match, and the list of algorithms that were used when the discover function ran. The approximate measurements that the algorithms returned for the matched pair are included. This page applies to proposed mappings. This is read-only.
Details Shows the details of the sources and targets in the mapping groups. This page applies to mapping groups. This is read-only.
Filter Shows the current filter expression on the matched pair in the Expression field. You can edit the field or create your filter expression here. You can open the Expression Builder from this view. This page applies to mapping groups.
Join Shows the current join condition on the matched pair in the Expression field. You can edit the field or create your join condition here. You can open the Expression Builder from this view. This page applies to mapping groups.
Sort Shows the current sort expression on the matched pair in the Sort field. You can open the Expression Builder from this view. This page applies to mapping groups.

Feedback