Step 2. Specify Parameters in the Mapping Template
Step 2. Specify Parameters in the Mapping Template
After you select the mapping template, use parameters to create two mappings. The parameters that you defined in the mapping template appear in the wizard.
You configured the following parameters in the mapping template:
$end$
. This parameter defines the target port.
$start$
. This parameter defines the source port that contains the data required in the target.
$Source$
. This parameter defines the source table.
Create two mappings with different values for the $end$ and $start$ fields. Enter the same value for the $source$ field.
The following example shows the settings for the two mappings you want to create, one listing for M_EmployeeID and another for M_EmployeeName:
These settings create two mappings that use the same source table, but extract different data and load the data to different ports of the same target table.
The Source table list shows available sources in the following format: