Mapping from source: by name

The Map by Name wizard is used to map complex types by examining the names of source elements and target elements to create mappings.

The Map by Name wizard can also be used to map database columns. The following steps describe how to map from source using the Map by Name wizard.

Using the Map by Name wizard

  1. Click the source and target complex elements, database, schema, or table that you want to map.
  2. Click Map > Map by Name. The Map by Name wizard opens to allow you to perform mapping by name.
  3. Choose the appropriate option from the Map from Source wizard:
    • Map leaves of the selected nodes. This option maps the leaves of the source element to the leaves of the target element, that match each other; this option is selected by default.
    • Map immediate children of the selected nodes. This option maps only the immediate children of the source element to the immediate children of the target element that match each other. This option is available only when the selected source and target elements have immediate children that are mappable.
  4. After selecting the Map leaves of the selected nodes or Map immediate children of the selected nodes option, specify how names are matched.
    • Map items of same names only. This option matches items of the same name, and is selected by default. Two names are considered to be the same if they contain the same alphanumeric characters in the same order. This comparison is not case sensitive, so FIRST_NAME and FirstName are considered to be a match.
    • Map items of same and similar names. This option matches items with similar names. Two names are considered to be similar if one name is a truncation of the other, for example, first_name and name, or PART_NUMBER and partNum. Also, if one name is a contraction of another, as in November and nvmbr, they are considered to be similar.
    The preceding two options are independent of one another, and you can select their values separately.
  5. Verify that the mappings are relevant and edit them manually if necessary. You might need to delete unwanted mappings and add extra mappings.

The Map by Name wizard opens automatically when you use the drag and drop method to map from source where the source and target are complex types with different type definitions, or where the source type is not derived from the target type.

Related concepts
Message Mapping editor
Creating message mappings
Related tasks
Mapping from source: by selection
Mapping a target element from source message elements
Mapping a target element from database tables
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2009Copyright IBM Corporation 1999, 2009.
Last updated : 2009-01-07 15:23:03

ar37510_