Mapping Specification Configuration > Map Source and Target Columns
  

Map Source and Target Columns

The Analyst tool can map source and target columns in a mapping specification based on column names and column positions. The Analyst tool can also map columns based on advanced criteria that you enter for column names and column positions. You can also select each source and target column to map the columns.
Use the Advanced mode in the Automap window to enter the column mapping criteria.
When you map by column name, the Analyst tool maps columns by name. For example, the Analyst tool maps ACCOUNTS to ACCOUNTS.
When you map by column position, the Analyst tool maps the first or last source column with the target column you select. For example, the Analyst tool maps the first source column ACCOUNTS_PAID to the target column ACCOUNTS.

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.
    1. From the Actions menu, click the Automap Columns icon.
    The Automap wizard appears.
    2. Choose to map columns in simple or advanced mode.
    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.
    3. Optionally, on the Transformation and Target Columns panel, click Refresh to update the mapping specification with mapped columns, and click OK.
    4. Click Save.

Mapping to Selected Columns

You can select each source column to map it to a target column in the mapping specification.
    1. On the Sources panel, select a source column.
    2. On the Transformations and Target Columns panel, select a target column.
    3. Click the Map to Selected Columns icon between the Sources and the Transformations and Target Columns panels.