By defining a field mapping file, you can specify the relationship between columns of the source file and those of the target table.
Definition template
The following example shows the definition template of a field mapping file (also known as a map file):
Column number in the source file: Column number in the target table
Column number in the source file: Column number in the target table
Column number in the source file: Column number in the target table
Column number in the source file: Column number in the target table
Example
The following example shows how to use a map file:
1:1 -- Import data in the first column of the source file into the first column in the target table
2:2 -- Import data in the second column of the source file into the second column in the target table
3:3 -- Import data in the third column of the source file into the third column in the target table