If you are using self-describing trails then any column on the source object is mapped to the same column name on the target object. You only need to manage column names that are different between source and target or if you need to transform a column.

However, if not using self-describing trails then the default mapping is done by column order and not the column name. So column 1 on the source will be mapped to column 1 on the target, column 2 to column 2 and so on.

Use the COLMAP option of the MAP and TABLE parameters to:

• map individual source columns to target columns that have different names.

• specify default column mapping when an explicit column mapping is not needed.

• Provide instructions for selecting, mapping, translating, and moving data from a source column into a target column.