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.