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.