Navigating the Mapping Editor FAQS

1. What is the Mapping Editor in ODI 12c?
• The Mapping Editor is a single environment in ODI 12c where you can design, edit, and manage data mappings. It allows you to visually organize data flows, define transformations, and configure the process of moving data from source to target.
2. How do I open the Mapping Editor for an existing mapping?
• To open an existing mapping, right-click the mapping in the Designer Navigator and select Open, or double-click the mapping to open it in the Mapping Editor.
3. How do I create a new mapping in ODI 12c?
• To create a new mapping, right-click the Mappings node under the desired project and select New Mapping. The new mapping will then open in a tab in the main pane of ODI Studio.
4. What are the different tabs available in the Mapping Editor?
• The Mapping Editor includes three main tabs:
• Overview: Displays general properties of the mapping.
• Logical: Shows the logical organization of the mapping.
• Physical: Displays the physical organization of the mapping.
5. What is the Mapping Diagram, and how do I use it?
• The Mapping Diagram is where you visually design and edit your mapping. You can drag datastores from the Models tree, Reusable Mappings, and components from the Component Palette into the diagram to define data operations and flows.
6. How do I edit the properties of a component in the Mapping Editor?
• To edit the properties of a selected object, use the Property Inspector at the bottom of the Mapping Editor. If it’s not visible, you can enable it by selecting Properties from the Window menu.
7. What is the Component Palette in the Mapping Editor?
• The Component Palette is located on the right side of the Mapping Editor. It contains all the available components (such as transformations, filters, etc.) that you can use in your mappings. You can drag and drop components from this palette into the mapping diagram.
8. How can I navigate through a large or complex mapping?
• Use the Thumbnail Panel, which provides a miniature view of the mapping. It displays a rectangle indicating the portion of the mapping currently visible. Clicking within the rectangle allows you to quickly navigate to different sections of the mapping.
9. What is the Structure Panel, and how do I use it?
• The Structure Panel provides a text-based hierarchical tree view of the mapping. It allows for easy navigation and quick access to various parts of the mapping. To open it, select Structure from the Window menu.
10. Can I switch between logical and physical views of the mapping?
• Yes, you can switch between the Logical and Physical views using the respective tabs at the bottom of the Mapping Editor. These views help you see the mapping at different organizational levels (logical vs. physical).
11. How do I manage multiple open mappings in ODI Studio?
• Each open mapping appears as a separate tab in the main pane of ODI Studio. You can click between the tabs to switch between different mappings.
12. What should I do if the Mapping Editor sections (e.g., Property Inspector, Component Palette) are not visible?
• If any sections are missing, you can enable them by selecting the corresponding options from the Window menu (e.g., Properties, Components, Structure, Thumbnail).