Running Mappings FAQS

1. What is the difference between running a mapping and simulating a mapping?

• Running a mapping actually executes the code and applies changes to the source and target data as per the mapping design.
• Simulating a mapping allows you to preview the execution behavior without actually making changes to the data, acting as a dry-run. This is useful for testing the logic before applying any data changes.

 

2. Can I run a mapping without using a logical agent?

• Yes, you can select Local (No Agent) as the logical agent when running a mapping, which uses the built-in agent in Oracle Data Integrator Studio instead of an external logical agent.

 

3. What should I do if the mapping is stuck or not running properly?

• Check the Session Status: Go to the Operator Navigator and look at the session details to verify the status.
• Review Validation Results: If there are errors or warnings in the mapping, they will be shown in the Validation Results pane.
• Check Logs: If the mapping failed, check the logs to identify specific issues such as connection problems or data issues.

 

4. How do I choose the correct context for running the mapping?

• The context defines the environment for executing the mapping (e.g., Development, Testing, Production). Choose the context that aligns with the environment in which you want to run the mapping. The context settings can affect data sources, target destinations, and other environment-specific configurations.

 

5. What do the different log levels mean when running a mapping?

• Log Level controls the amount of detail shown in the logs during mapping execution. Common log levels include:
• Minimal: Shows only essential information (e.g., start and end of execution).
• Medium: Provides additional detail on processes and errors.
• Detailed: Gives full trace-level information for debugging purposes.

 

6. Can I cancel or stop a running mapping session?

• Yes, you can stop a running session. Go to the Operator Navigator, find the session you want to stop, and choose the Stop option. Be mindful that stopping a session mid-execution could leave data in an inconsistent state depending on the process.

 

7. Why is my mapping failing during execution?

• There could be several reasons for failure:
• Data issues: Missing or incorrect data in source/target systems.
• Connection issues: Problems connecting to the source/target databases.
• Configuration errors: Incorrect context or mapping design.
• Validation errors: Warnings or errors reported in the Validation Results pane.

 

8. How can I monitor the progress of my mapping execution?

• You can track the progress of your mapping execution in the Operator Navigator by checking the session details. The session icon will indicate whether the process is still running, has completed successfully, or stopped due to an error.

 

9. What should I do if I encounter warnings during the validation process?

• Warnings may not prevent the mapping from running, but they could indicate potential issues that could affect the output. Review the warning messages, identify any discrepancies in your mapping design or data, and address them before running the mapping again.

 

10. Can I run multiple mappings at once?

• Yes, you can run multiple mappings in parallel if your environment supports it. Ensure that your system has sufficient resources to handle multiple processes simultaneously. In ODI, you can use multi-threading or parallel execution for better performance.

 

11. How do I check the status of a mapping execution?

• The status of a running session can be monitored in the Operator Navigator under the Session List. Each session will have an icon indicating whether it's still running, completed, or failed.

 

12. How do I troubleshoot an error in a mapping?

• Review the logs: Check the detailed logs for specific error messages.
• Check data sources: Ensure that your source and target databases are properly connected and contain the expected data.
• Review the Mapping Design: Verify that the mapping logic is correct and matches the source and target structures.

 

13. Can I modify a mapping after it has started executing?

• No, once a mapping execution has started, you cannot modify the mapping itself. You would need to stop the session, make changes to the mapping, and then re-run it.

 

14. How do I troubleshoot simulation errors?

• If you encounter issues during a simulation run:
• Check the Validation Results: It will show any logical errors or issues in the mapping design.
• Verify the Simulation Settings: Ensure you’ve selected the correct context and logical agent for the simulation.

 

15. Is it possible to automate the running of mappings?

• Yes, Oracle Data Integrator supports the automation of processes, including running mappings through scheduled jobs. You can set up automation tasks through ODI Scheduler or by integrating with other scheduling tools.