Attribute Matching

1. Triggering the Attribute Matching Dialog:

• The Attribute Matching Dialog is triggered when you draw a connector to a projector component (such as a Set component) in the Mapping Editor.

2. Understand the Purpose of the Dialog:

• The dialog allows you to automatically map attributes from the source to the target component.
• You can also use it to create new attributes on either the source or the target based on the other component's attributes.

3. Mapping Attributes Automatically:

• The dialog gives you options to create expressions that map attributes based on a matching mechanism:
• By Name: Automatically matches attributes from the source to the target by name.
• By Position: Matches attributes by their position in the components.
• You can use these options to create attribute mappings automatically without manually defining them.

4. Option to Create New Attributes:

• The dialog provides the option to:
• Create new attributes on the target based on the source. This is useful if the target component does not have the attributes from the source.
• Create new attributes on the source based on the target. This is useful if the source component needs attributes from the target.

5. Example: Using the Set Component:

• If you connect a new, empty Set component to a downstream target datastore, you can enable the Create Attributes On Source option in the dialog.
• Create Attributes On Source: When checked, this option will populate the Set component with all of the attributes from the target datastore.
• When you then connect the Set component to upstream components, you will already have the target attributes available for mapping. This saves time, as the attributes are automatically created in the Set component.

6. Map Attributes to Set Component:

• After the Set component is populated with attributes, you can then use the Mapping Editor to connect upstream components and map the upstream attributes to the pre-defined target attributes in the Set component.

7. Finalizing the Mapping:

• Once the attributes are automatically mapped or created, you can review the connections and make any necessary adjustments. The Property Inspector will allow you to fine-tune the details of each mapping or expression.

Summary:

The Attribute Matching Dialog streamlines the process of mapping and creating attributes in ODI 12c. By using it, you can automatically match or create attributes based on the components' source and target, allowing for efficient data flow management.