See information about the latest product version
Mapping by same name or similar name
Options are available when you select Create transforms when the names of inputs and outputs are the same or a similar name.
When you select Create transforms when the names of inputs and outputs are the same, the following rules apply:
- Any output field that has a fixed value is excluded in name matching. Any output that is already mapped, or under a container that is already mapped, is excluded from name matching.
- If an input and an output have the same name, it is a match, regardless of the kind of, and XSD type of, the input and output. An element, an attribute, and a database column can all form a match if their names are the same.
- XML namespaces are excluded from name matching. Therefore, abc:something and xyz:something are considered the same, as are {http://www.abc.com}:something and {http://www.xyz.com}:something.
- When multiple inputs have the same name
as one output, one mapping is created. For example:
However, if you have multiple inputs with the same name as one output and you choose to map by the same name (or similar name) and to match descendants, an attempt is made first to match by path and name. If a match is found, one transform is made, and no further matches are considered.
- When a single input has the same name as multiple outputs, multiple
mappings are created, each for one input and one output. For example:
However, if you have a single input with the same name as multiple outputs and you choose to map by the same name (or similar name) and to match descendants, an attempt is made first to match by path and name. If a match is found, one transform is made, and no further matches are considered.
- When you select the Map all simple descendants
of the selected elements option, the following steps are
taken to match names:
- Compare the relative path and item name of the selected input and output
- Compare the item name without relative path
For example, assume you have the following input and output items:- Input:
OldPurchaseOrder items item partNum partNum
- Output:
NewPurchaseOrder items item partNum resource partNum
If you select Create transforms when the names of inputs and outputs are the same when you have the inputs and outputs shown above, the relative paths of all the items are:- Relative paths of the input items:
items/item/partNum partNum
- Relative paths of the output items:
items/item/partNum resources/partNum
During step a) items/item/partNum and items/item/partNum are matched.
During step b) partNum and resources/partNum are matched.
Inputs and outputs matched in a previous step are ignored in later steps.
When you select the Map the immediate children of the selected elements option, the only step taken to match names is to compare the item name without the relative path.
Mapping by similar name
- Fixed value outputs and mapped outputs are excluded in name matching; see Point 1 in the preceding section.
- The similarity test is done using the name of an element, an attribute, or a database column regardless of its type; see Point 2 in the preceding section.
- The similarity test applies in the same way to case sensitivity and alphanumeric characters as for Mapping by same name.
- Namespace or namespace prefixes do not participate in the similarity test; see Point 3 in the preceding section.
- The behavior for the situation when multiple inputs are similar to one output, and when multiple outputs are similar to one input, is the same as Point 4 in the preceding section.
- When you select Map all simple descendants of the
selected elements, the following steps are taken to match
names.Inputs and outputs matched in a previous step are ignored in later steps:
- Compare the relative path and item name of the selected input and output
- Compare the item names without relative path
- Compare similar item names without relative path
When you select the Map the immediate children of the selected elements option, the only step taken to match names is to compare similar item names without the relative path.
- You can select the similarity threshold for two words to be considered similar.
- You cannot use any other similarity algorithm.