Attribute Matching FAQS

1. What triggers the Attribute Matching Dialog in ODI 12c?
• 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. What is the purpose of the Attribute Matching Dialog?
• The dialog allows you to automatically map attributes from a source component to a target component, as well as create new attributes in the source or target component based on the other component’s attributes.
3. Can I automatically map attributes from the source to the target?
• Yes, you can automatically map attributes using the Attribute Matching Dialog by selecting the matching mechanism (either by name or by position). This will create attribute mappings automatically without needing to define them manually.
4. What does the "Create Attributes On Source" option do?
• When you check the "Create Attributes On Source" option, the Set component will be populated with all the attributes of the target datastore. This allows you to easily map the upstream components to the target attributes, which are already defined in the Set component.
5. What happens if I don’t check the "Create Attributes On Source" option?
• If you don’t check this option, the Set component will not automatically have the target attributes. You will need to manually create or define the attributes in the Set component before mapping.
6. Can I create new attributes in the source or target component using the dialog?
• Yes, the dialog gives you the option to create new attributes on either the source or the target based on the attributes of the other component.
7. What is an example use case for using the Attribute Matching Dialog?
• A common use case is when you have a Set component connected to a target datastore. By using the Attribute Matching Dialog, you can automatically create attributes in the Set component that match those in the target datastore, saving time and effort in manually defining each attribute.
8. Can I manually edit the attribute mappings after using the Attribute Matching Dialog?
• Yes, after using the dialog, you can still edit the attribute mappings or the component properties manually in the Property Inspector if needed.
9. What does the "Create Attributes On Target" option do?
• The "Create Attributes On Target" option allows you to create new attributes on the target component based on the attributes of the source component. This is useful when the target datastore does not yet have the required attributes.
10. Can the Attribute Matching Dialog help in data flow design?
• Yes, the Attribute Matching Dialog helps streamline data flow design by automatically handling attribute mappings and attribute creation, making the process more efficient and reducing the chance of errors.