Creating a New Mapping FAQS

1. What is the first step to create a new mapping in ODI 12c?
• The first step is to select the Mappings node in the Designer Navigator under the folder of your project where you want to create the new mapping.
2. How do I create a new mapping?
• After selecting the Mappings node, right-click on it and choose New Mapping. This will open the New Mapping dialog where you can define the mapping’s name and optionally a description.
3. What is a Dataset in ODI 12c, and do I need it?
• A Dataset is an optional component in ODI 12c that helps define data flows using an entity relationship model. While Datasets are not mandatory, they may be useful for users familiar with earlier ODI versions or for creating data flows faster in certain cases. You can create data flows using other components even without a Dataset.
4. Can I create a mapping without a Dataset?
• Yes, you can create a mapping without a Dataset. Datasets are optional, and all behavior related to data flows can be accomplished using other components in the Mapping Editor.
5. What happens if I choose to create an empty Dataset during mapping creation?
• If you choose to create an empty Dataset, it will be included in your mapping as an entity-relationship model. However, this is just an option and you can add or remove the Dataset later if needed.
6. Can I modify the mapping after it’s created?
• Yes, once a mapping is created, you can open and modify it at any time by clicking on the mapping tab in ODI Studio. You can add components, adjust properties, or remove datasets as necessary.
7. How do I open and edit an object like a datastore or reusable mapping in the new mapping?
• To open and edit any object (e.g., a datastore or reusable mapping) used in your new mapping, simply right-click the object in the Mapping tab and select Open.
8. What if I don’t want to create a Dataset while creating the mapping?
• You can leave the Create Empty Dataset option unchecked in the New Mapping dialog. This allows you to create the mapping without the Dataset, and you can always add it later if needed.
9. Can I delete or remove a Dataset after the mapping is created?
• Yes, you can add or remove a Dataset after creating the mapping. Datasets are optional and do not impact the core functionality of the mapping.
10. How is the physical diagram generated when using a Dataset?
• When using a Dataset, the physical diagram is generated automatically by ODI 12c. The entity relationships in the Dataset are converted into a flow diagram and merged with the surrounding flow, so you don't need to manually connect or modify the flow.