About the Physical Mapping Diagram FAQS

• Physical Mapping Design
• Execution Groups
• Source Execution Group(s)
• Target Execution Group(s)
• Execution Units
• Access Points
• Components
• Loading Knowledge Modules (LKMs)
• Integration Knowledge Modules (IKMs) and Check Knowledge Modules (CKMs)

About the Physical Mapping Diagram

• Physical Mapping Design
• Execution Groups
• Source Execution Group(s)
• Target Execution Group(s)
• Execution Units
• Access Points
• Components
• Loading Knowledge Modules (LKMs)
• Integration Knowledge Modules (IKMs) and Check Knowledge Modules (CKMs)

Physical Design FAQS

1. What is the Physical Design Tab used for?

• The Physical Design Tab shows the distribution of execution across different physical servers or execution units. It helps you visualize and manage the execution of your mapping in terms of physical resources.

2. What is the default physical mapping design?

• The default physical mapping design is automatically computed by ODI based on the logical design, topology, and any rules you've defined. It provides a baseline for how the mapping will be executed across physical execution units.

3. Can I customize the default physical design?

• Yes, you can customize the physical design using the physical diagram. This allows you to move components between execution units or create new execution units on the diagram background.

4. What is the role of Execution Units in the Physical Design?

• Execution Units represent the physical servers where tasks will be executed. You can move components between execution units to control where and how they run.

5. What are Execution Groups, and why should I use them?

• Execution Groups are collections of execution units that enable parallel execution. Grouping execution units into an execution group allows tasks to run simultaneously, improving performance and efficiency.

6. Can I have multiple physical mapping designs for a single mapping?

• Yes, a mapping can have multiple physical mapping designs. These designs are displayed as separate tabs under the physical diagram, allowing you to define and test different execution strategies.

7. How do I create a new physical mapping tab?

• To create a new physical mapping tab, click on the Create New Tab option. This will allow you to create a new physical design for the same mapping with a different execution strategy.

8. How do I delete a physical mapping design tab?

• To delete a physical mapping design tab, right-click on the tab you want to remove and select Delete from the context menu. This will remove the selected physical mapping design permanently.

9. What are physical components, and how do they differ from logical components?

• Physical components define how the mapping is executed at runtime and represent the actual physical resources. They may have different properties compared to their logical components, which describe the structure or logic of the data without specifying how or where it will be executed.

10. Can I undo changes made in the physical diagram?

• Depending on the platform and configuration, changes made in the physical design may not be easily undone. It's recommended to save versions of your design or create backups before making major changes.

11. Do I need any special permissions to manage physical designs?

• Yes, you may need specific permissions to modify or delete physical mapping designs. Ensure you have the necessary access rights or consult with an administrator if you encounter permission issues.

12. Can I adjust the physical design during runtime?

• While you can adjust the physical design before execution, changes during runtime typically aren't allowed. Adjustments to execution strategies should be made before initiating the mapping process.

Physical Design

1. View the Physical Design Tab:

• Navigate to the Physical tab to view the distribution of execution among different execution units representing physical servers.
• ODI (Oracle Data Integrator) computes a default physical mapping design based on the logical design, the topology, and any rules you’ve defined.

2. Customize the Physical Design:

• You can adjust the default physical mapping design by using the physical diagram.
• Move components between execution units, or drag them onto the diagram background to create a new execution unit.

3. Group Execution Units:

• Multiple execution units can be grouped together into execution groups.
• Execution groups enable the parallel execution of the contained execution units.

4. Create Multiple Physical Mapping Designs:

• A mapping can have multiple physical mapping designs. These designs are listed in tabs under the physical diagram.
• Having multiple physical designs allows you to define different execution strategies for the same mapping.

5. Create a New Physical Mapping Tab:

• To create a new physical mapping tab, click Create New Tab.
• This allows you to create a new execution strategy or design.

6. Delete a Physical Mapping Design Tab:

• To delete a physical mapping design, right-click on the physical mapping design tab you wish to remove.
• Select Delete from the context menu to permanently remove the tab.

7. Understand Physical Components:

• Physical components represent how a mapping is executed at runtime.
• They are the physical representation of logical components and may have different properties depending on the logical component they represent.