Creating a Mapping FAQS

1. What is the process for creating a mapping in ODI 12c?
• The process for creating a mapping involves defining the logical diagram first, where you drag components and establish connections. Once the logical design is complete, you move to the physical diagram to configure where and how the integration process will run. After finalizing both designs, you can execute the mapping.
2. What is the difference between the logical and physical diagrams in the Mapping Editor?
• The logical diagram represents the conceptual design of your mapping, including how data flows between components. The physical diagram specifies how the integration will be executed on your infrastructure, defining which systems, servers, or databases will be involved.
3. How do I add components to the mapping diagram?
• To add components to the mapping diagram, you can drag components (such as datastores, transformations, or filters) from the Component Palette and drop them onto the diagram.
4. How do I connect components in the mapping diagram?
• You can drag connections between the components by clicking and dragging a line from one component to another. This defines the data flow between them.
5. How do I define the data flow between components?
• To define the data flow, you drag attributes across the connections between components. This specifies how data will be transferred, transformed, or filtered through the mapping.
6. How can I modify the properties of components in the mapping?
• You can modify the properties of selected components using the Property Inspector. The Property Inspector allows you to adjust settings like transformation rules, data types, and other component-specific configurations.
7. When do I switch from the logical to the physical diagram in the Mapping Editor?
• After completing the logical design (i.e., defining components and connections), you switch to the physical diagram to specify how and where the mapping will be executed on your physical infrastructure.
8. Can I preview or test the mapping before running it?
• While you cannot "preview" the mapping in the traditional sense, you can validate the mapping by checking for errors and ensuring that the logical and physical configurations are correct before running it.
9. How do I run a mapping in ODI 12c?
• Once the logical and physical designs are complete, you can run the mapping by selecting the appropriate execution option within the Mapping Editor or the ODI Studio interface to trigger the data integration process.
10. Can I edit a mapping after it has been created?
• Yes, you can edit the mapping at any time by opening it in the Mapping Editor. You can modify components, change connections, adjust properties, or update the physical diagram as needed.
11. What happens if I make an error in the mapping design?
• If there is an error in the design, you can identify and fix it by reviewing the Property Inspector and the mapping components. ODI 12c will typically show warnings or errors in the execution process if there are issues in the design.
12. How do I organize mappings within a project?
• Mappings are organized within folders under a project in the Designer Navigator. You can create new folders to better organize your mappings and manage them more efficiently.