About this task
When you select
Create
transforms when the names of inputs and outputs are more similar than,
the following rules apply:
- Fixed value outputs and mapped outputs are excluded in name matching.
- The similarity test is done using the name of an element, a database
column, or an attribute regardless of its type. 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, a database column, or an attribute can all form a match if their names are the
same.
- 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. 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. 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 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.