Connecting and Configuring Components

1. Open the Mapping Editor:

• Ensure the Mapping Editor is open for the mapping you are working on.

2. Create Connectors Between Components:

• Drag from the Originating Connector Port:
• Select the connector port of the component you want to connect (source).
• Drag the connection line from the originating port to the destination connector port (target) of the next component in the flow.
• Implicitly Create Connectors by Dragging Attributes:
• Alternatively, you can drag attributes (e.g., from one component’s attributes to another component’s matching attributes) to implicitly create connectors.
• When you drag an attribute between two components, ODI will automatically create the connection between the components.

3. Attribute Matching Dialog (If Applicable):

• When you create a connector between two components, ODI may display the Attribute Matching Dialog.
• This dialog allows you to choose how the attributes will be mapped between the components.
• By Name: ODI will match the attributes based on their names. If attributes in the source and target have the same name, they will be mapped automatically.
• By Position: ODI will match the attributes based on their position in the list. Attributes in the same order on both components will be automatically mapped.

4. Configure the Connector:

• After creating a connector, you may need to configure the connector settings (if applicable).
• This can include specifying how data is transferred between the components, adjusting the properties of the connector, and ensuring it matches the data flow logic for the mapping.

5. Verify the Connection:

• Once the connectors are created and configured, ensure that the data flow is correct by checking the Mapping Diagram.
• If any attributes need adjustment or if you want to apply transformations, you can edit the connections in the Property Inspector.