Mapping Connectors FAQS

1. What are connectors in ODI 12c?
• Connectors are used to create the flow of data between mapping components in ODI 12c. They define the pathways for data to move from one component to another, either as input or output.
2. What is the difference between input and output connectors?
• Input connectors are used to bring data into a component, while output connectors send data from a component to another component or datastore.
3. What are datastores in the context of connectors?
• Datastores with only output connectors are considered sources, while datastores with only input connectors are considered targets in a mapping.
4. Can components have multiple connectors?
• Yes, some components, such as the split component, can support multiple output connectors. This allows the data to be divided and sent to multiple downstream components or flows.
5. What are connector points?
• Connector points define the actual connections between components. They represent a single pathway for input or output between components inside a mapping.
6. What are connector ports?
• Connector ports are the small circles displayed on the left and/or right sides of components in the mapping diagram. These ports represent where connectors attach to the component.
7. How are connectors displayed in the mapping diagram?
• In the mapping diagram, connectors between components are shown as a single visible line between their connector ports, regardless of how many actual connector points exist between them.
8. How can I view details about a connection between two components?
• You can select the line connecting components in the mapping diagram to view details about the connection. The property inspector will display information about the selected connection.
9. Can I edit the connectors in ODI 12c?
• Yes, you can edit connectors by adjusting the input/output connections in the Mapping Editor. You can modify the flow of data or change which components are connected.
10. What happens if there are multiple output connectors in a component?
• If a component has multiple output connectors (e.g., a split component), data can be routed to multiple downstream components, allowing parallel or split processing of the data.
11. Are connectors important for performance in ODI?
• Yes, correctly managing connectors is crucial for optimizing the flow of data in your mapping, especially when dealing with large volumes of data or complex transformations. Well-structured mappings ensure smoother performance.