Letting FM/Db2 do the mapping
If you want, you can use FM/Db2 to set up the mappings. This happens
automatically if you do not select the Edit template mapping on
the Copy To
panel. If no mapping exists in the To
template,
FM/Db2 performs a corresponding move by going through the following
two steps:
- Generates mappings based on column names. That is, columns in
the
From
template are mapped to like-named columns in theTo
template. FM/Db2 provides mappings for as many columns as it can in this way. - For the remaining
unmatched
columns in theFrom
template (if any), FM/Db2 generates mapping based on data attributes:- FM/Db2 compares the attributes of the first unmatched column in
the
From
template with the attributes of the first unmatched column in theTo
template. If the attributes of the two columns are the same, FM/Db2 generates mapping between the two columns. - FM/Db2 repeats the preceding step with the next pair of unmatched
columns in the two templates until either it has generated mapping
for all the columns in the
From
template, or if it finds the attributes of the two columns do not match.
- FM/Db2 compares the attributes of the first unmatched column in
the
Related references