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.
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. ![]() ![]() |
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. |