Running Mappings

1. Open the Mapping
• From the Projects menu in the Designer Navigator, right-click the mapping you want to run and select Run.
• Alternatively, if the mapping is open in the Mapping Editor, click the Run icon in the toolbar or select Run from the Run menu.
2. Select Execution Parameters
   In the Run dialog, you'll need to choose the following parameters:
• Context: Select the context into which the mapping should be executed. Contexts define different environments or configurations for running the mapping.
• Physical Mapping Design: Select the physical mapping design you wish to run.
• Logical Agent: Choose the logical agent responsible for running the mapping. You can also select Local (No Agent) to use the built-in agent in Oracle Data Integrator Studio.
• Log Level: Select the log level to control the detail of the messages that appear in the validator when the mapping runs.
• Simulation: If you want to preview the code execution without making any changes to the data (i.e., simulate the run), check the Simulation box.
3. Click OK
   Once you've selected all the parameters, click OK to start the mapping.
4. Information Dialog
• After clicking OK, the Information dialog will appear. If the session starts successfully, you’ll see the message Session started.
• Click OK to close the dialog.
5. Review Validation Results
• When the mapping runs, the Validation Results pane opens, where you can review any warnings or errors related to the mapping.
6. Monitor the Session
• You can monitor the status of your session in the Operator Navigator under the Session List.
• Expand the Sessions node, then expand the mapping you ran to see its session details. The session icon indicates whether it is still running, completed, or stopped due to errors.

 

Additional Notes:

• The Simulation option allows you to test the execution without affecting data on the source or target datastores. It's useful for previewing code behavior.
• If you encounter any errors or warnings during validation, they will be shown in the Validation Results pane.
• For detailed guidance, refer to the Running Integration Processes chapter in the Administering Oracle Data Integrator documentation.