Mapping Source and Target Columns by Name or Position
Mapping Source and Target Columns by Name or Position
When you map source and target columns by column name, the Analyst tool ignores source and target prefixes and suffixes. When you map source and target columns by column position, the Analyst tool maps the first or last source column with the target column you select.
From the
Actions
menu, click the
Automap Columns
icon.
The
Automap
wizard appears.
Choose to map columns in simple or advanced mode.
To map columns in the simple mode, select
Simple
.
To map columns in the advanced mode, select
Advanced
and choose to map columns by name or column position.
In the Simple mode, the Analyst tool maps columns with the same name or position. In the Advanced mode, the Analyst tool maps columns based on either name or position.
Optionally, on the
Transformation and Target Columns
panel, click
Refresh
to update the mapping specification with mapped columns, and click