Navigation:  Business Operations > Transfer Manager >

Source-target Mapping

Training Manuals Alphabetical Function List Back Print this Topic Previous topicOne level upNext topic
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:

 

hmtoggle_plus1Number Of Columns To Map For Target

It is a spin control used to indicate the number of columns to map for the target selected.

hmtoggle_plus1Source-Target File Mapping Grid

The following is displayed in the grid:

 

UPDATE COLUMN

When the mode Update Records Only or Insert Records And Update Records If Exist is selected on the Advanced Settings tab, the fields to be updated must be flagged (selected) in this row.

 

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".

 

SOURCE COLUMNS

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.

 

FIXED STRING

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.

 

FIXED VALUE

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.