Navigating the Mapping Editor

1. Overview of the Mapping Editor:
• The Mapping Editor provides a single environment to design and edit mappings in ODI 12c.
• Mappings are organized into folders within a project in the Designer Navigator. Each folder contains a Mappings node, which lists all the mappings.
2. Opening the Mapping Editor:
• To open an existing mapping: Right-click on the mapping and select Open, or double-click the mapping.
• To create a new mapping: Right-click on the Mappings node and select New Mapping.
• The mapping is opened as a tab in the main pane of ODI Studio.
• To view the Mapping Editor, select the tab corresponding to the mapping.
3. Mapping Editor Layout: The Mapping Editor is divided into several sections:
• Mapping Diagram (Middle):
• Displays an editable logical or physical view of the mapping.
• These views are sometimes called logical diagram or physical diagram.
• You can drag datastores from the Models tree, Reusable Mappings from the Global Objects or Projects tree, and components from the component palette to define data operations.
• Mapping Editor Tabs (Middle, at the bottom of the mapping diagram):
• Overview Tab: Displays the general properties of the mapping.
• Logical Tab: Displays the logical organization of the mapping in the diagram.
• Physical Tab: Displays the physical organization of the mapping in the diagram.
• Property Inspector (Bottom):
• Shows the properties of the selected object in the mapping editor.
• If it is not visible, you can enable it by selecting Properties from the Window menu.
• Component Palette (Right):
• Displays available mapping components that can be used to create mappings.
• You can drag and drop components into the logical mapping diagram.
• If the component palette is not visible, you can enable it by selecting Components from the Window menu.
• Structure Panel (Not shown by default):
• Displays a text-based hierarchical tree view of the mapping, which can be navigated using the tab and arrow keys.
• To open the Structure Panel, select Structure from the Window menu.
• Thumbnail Panel (Not shown by default):
• Displays a miniature graphic of the mapping with a rectangle indicating the portion currently visible in the mapping diagram.
• This panel is useful for navigating very large or complex mappings.
• To open the Thumbnail Panel, select Thumbnail from the Window menu.
4. Working with the Mapping Editor:
• You can interact with the mapping diagram by dragging and dropping components and datastores.
• Use the Property Inspector to modify settings and configurations for the selected mapping objects.
• Switch between the Logical and Physical views to understand and edit the mapping’s organization at different levels.
5. Viewing the Mapping Structure:
• The Structure Panel offers a detailed view of the mapping's components in a hierarchical format.
• It helps you quickly navigate through the mapping elements.
6. Navigating Large Mappings:
• Use the Thumbnail Panel to get a quick overview of the entire mapping, especially when dealing with large or complex diagrams.
• The Thumbnail Panel provides a way to focus on a specific part of the mapping by clicking within the rectangle representing the visible area.