Introduction to Mappings FAQS

1. What is a mapping in ODI 12c?
• A mapping in ODI 12c is the logical and physical representation of data flows between source and target systems, including any necessary data transformations. It is created and managed using the Mapping Editor in ODI.
2. How do I create a new mapping in ODI 12c?
• You can create a new mapping by opening the Mapping Editor and selecting the option to create a new mapping. The mapping will be stored under a specific project within the Designer Navigator.
3. What is the Mapping Editor?
• The Mapping Editor is a tool in ODI 12c that allows users to design, manage, and configure mappings. It helps in visualizing and defining the flow of data from sources to targets along with transformations.
4. Where can I find the mappings in ODI 12c?
• Mappings are organized in folders within individual projects. These projects are accessible under the Projects section in the Designer Navigator in ODI 12c.
5. How do I modify an existing mapping?
• To modify a mapping, simply open the mapping in the Mapping Editor, make the necessary changes, and save the mapping. You can edit data sources, targets, and transformations directly within the editor.
6. Can I organize my mappings in ODI 12c?
• Yes, mappings are organized into folders within the Designer Navigator. You can create multiple folders to better manage and categorize your mappings.
7. What happens when I open a mapping in ODI 12c?
• When you open a mapping, the Mapping Editor opens automatically. Here you can view and modify the data flow, sources, targets, and transformation logic.
8. What are the advantages of using mappings in ODI 12c?
• Mappings in ODI 12c provide a visual interface to design and manage data integration tasks, making it easier to handle complex data flows, automate transformations, and track data movement from source to target systems.
9. Can I reuse mappings in different projects?
• Yes, you can reuse mappings in different projects by exporting and importing them as needed.
10. What types of transformations can be used in mappings?
• ODI supports various transformations such as filtering, joining, aggregating, and data type conversions. These can be applied to data as it flows from the source to the target.
11. Is there a way to automate the execution of mappings?
• Yes, mappings can be scheduled and automated in ODI to run at specific times or triggered by events.
12. Can I debug a mapping in ODI 12c?
• Yes, ODI 12c provides debugging features in the Mapping Editor, which help in testing and troubleshooting the data flow and transformations in the mapping.