Adding and Removing Components FAQS

1. How do I add a component to a mapping in ODI 12c?
• To add a component, open the Mapping Editor, then drag components from the Component Palette into the logical diagram. You can also drag datastores and reusable mappings from the Designer Navigator into the mapping diagram.
2. What types of components can I add to a mapping?
• You can add a variety of components, including transformations, filters, operations, joins, lookups, and datastores (source and target), as well as reusable mappings.
3. How do I remove a component from a mapping?
• To remove a component, select it in the logical diagram, then either press the Delete key on your keyboard or right-click and choose Delete from the context menu.
4. Is there a confirmation required when deleting a component?
• Yes, a confirmation dialog will appear asking you to confirm the deletion of the component. You must click Yes to finalize the removal.
5. What are source and target datastores in ODI 12c?
• Source datastores are where the data comes from (data extraction), and target datastores are where the processed data will be loaded. Data flows from source to target through the defined components.
6. Can I rearrange components once they are added to the mapping?
• Yes, you can rearrange components in the mapping diagram by dragging them to different locations within the diagram. This won't affect their functionality but will help organize the flow visually.
7. Do I need to add a source and target datastore to every mapping?
• Yes, every mapping requires at least one source datastore (where data originates) and one target datastore (where data will be loaded). These define the start and end points of your data flow.
8. Can I add multiple sources or targets in a single mapping?
• Yes, you can have multiple source datastores and target datastores in a single mapping, depending on the complexity of your data flow and requirements.
9. What happens if I delete a source or target datastore?
• Deleting a source or target datastore will remove the data flow path and might cause errors in your mapping if it’s still being referenced. Always ensure that the datastore is not linked to other components before deleting it.
10. Can I add components after the mapping has been created?
• Yes, you can add, modify, or remove components at any time after the mapping has been created. Simply open the mapping in the Mapping Editor and make the necessary changes.
11. Can I add a component and then delete it later?
• Yes, you can add components to a mapping at any point in the design process and remove them later if they are no longer needed or if changes are required.