Properties for parameterized sources and connections
Properties for parameterized sources and connections
The
Sources
page appears in the mapping task wizard if you defined a parameter for the connection or source object in the associated mapping.
If you defined a parameter for the source connection in the mapping, you must select or create a specific connection for the mapping task. Ensure that the connection type is consistent with the source object type. After you select a connection, you can click
Advanced Options
to configure the optional advanced properties. For more information about these advanced properties, see
VSAM source properties in mappings.
If the mapping uses a specific source connection, you can specify these advanced properties in the mapping and also specify them in the mapping task. In this case, the properties in the mapping task override those in the mapping.
If you are parameterizing a source table, select the tables that correspond to the groups you selected in the mapping from the mapping task
Sources
tab. The number of tables you select must match the number of groups that were added in the multi group data object parameter. To select the source tables, click
Select
.
To parameterize a source table, you must define a parameter of the type
multi group data object
for the mapping.
By default, the tables are associated with the groups in the order in which the tables appear in the table selection window. From the
Group Map
area, you can change the group to table association by using drag and drop to associate a group with a table.
When you finish entering information on the
Sources
page, click
Validate
to validate your entries.
If the mapping specifies a connection parameter and you edit the mapping to change the source object, check the specific connection in the mapping task to determine if you need to reset it and then