The mappings are represented in the editor by lines that are drawn between the source and target nodes. Each mapping line contains a hub in the middle of the line. The color of the line depends on the type of mapping. Discovered mapping lines contain hubs that appear as brackets. All other mapping lines contain square hubs.
You can select a mapping line by clicking the mouse button anywhere on the line or the hub of the line. The color of the selected mapping line appears darker than the unselected lines (unless you have changed the defaults in the Mapping Editor preferences that are defined in the Workbench Preference page). You can select multiple lines by pressing the control key (CTRL) while selecting mapping lines. Each mapping line that you select while pressing the control key becomes part of the mapping selection. You can apply the options from the context menu to the mapping line or lines that you select. The appearance of the mapping line hub changes depending on the existence of refinements, such as transformations or expressions, that you add to the mapping group.
A mapping connects one or more source columns to a single target column or an XML schema document (XSD) simple element or attribute. When you generate scripts from a mapping model, the source information from each mapping is transformed (if you select an optional transformation function), and the result is viewed in terms of the mapping target. You can create mappings manually by right-clicking on the source and target elements and then clicking the Create Mapping menu option. You can create mappings automatically by running the discover function and then accepting the discovered mappings. You can delete the mappings by right-clicking the mapping line and selecting Remove Mapping from the menu option.
A mapping group contains mapped elements by target table (in a relational database). There will be one query that is generated for each mapping group. When you create a mapping, the mapping editor tries to include that mapping in an existing mapping group. If there is no appropriate mapping group the mapping editor creates a new mapping group.
A discovered mapping is a mapping that is proposed when you run the discover function. Discovered mappings are visible in the mapping editor and they are saved in the mapping model. They are ignored when you generate scripts from the mapping model. You can accept a discovered mapping by right-clicking on the discovered mapping line and then selecting the Accept Mapping menu option. You can delete a discovered mapping by right-clicking on the discovered mapping line and then selecting the Reject Mapping menu option. You can select multiple discovered mapping lines to accept or reject more than one discovered mapping at one time. You can also accept or reject all of the discovered mappings by right-clicking in the mapping editor and then selecting either Accept All Mappings or Reject All Mappings from the menu options. You can select Undo from the tool bar to reverse Accept or Reject actions.