|Show/Hide Hidden Text|
The Source-Target Mapping tab allows the user to specify which source column must be transferred to which target column. Note that fixed values and fixed strings can also be specified.
On this tab the following fields can be viewed:
It is a spin control used to indicate the number of columns to map for the target selected.
The following is displayed in the grid:
TARGET COLUMN NAMES
Displays the names of the columns of the selected target table in the sequence that it will be inserted into the target table.
TARGET DATA TYPE
Specifies the data type of the "Column Name".
It initially displays the sequence numbers of the columns in the target table. The sequence of the columns in the source file can be manipulated with the values in this row.
Whenever a fixed string (constant) must be inserted in a text column, the value can be specified in this row and the source column number must be made zero.
Whenever a fixed value (constant) must be inserted in a text column, the value can be specified in this row and the source column number must be made zero.
DATA SOURCE ROW 1, 2, 3
Displays the first three lines of the source table. It will change, depending on the settings on the Advanced Settings tab and the value of the source columns. This enables the user to validate the mapping of source to target file.
When the "Fixed Width File" source type is selected the following additional columns are displayed in the grid:
START AT CHARACTER#
It is the column in the row where the column starts.
STOP AT CHARACTER#
It is the column in the row where the column ends.