Configure a mapping task for a mapping with a Sequential File source. When you run the mapping task, the records are transmitted to the target. You cannot run mappings for the Sequential File Connector.
Note: SQL ELT optimization and Visio templates are not supported for Sequential File mapping tasks.
To begin configuring a mapping task, perform one of the following actions:
•In Data Integration, click New > Mapping Task and then click Create.
•While the mapping is open, select New Mapping Task from the Actions menu.
Then enter information on some or all of the following pages in the mapping task wizard:
•General. Enter a name for the mapping task, a project or folder location for the mapping task, and the runtime environment that contains the Secure Agent or Secure Agent Group under which the mapping task will run. If you began creating the mapping task without first opening the mapping, you must also select the mapping with which to associate the mapping task. The description is optional.
•Sources. This page appears only if you defined a parameter for the connection or source object in the mapping. If you defined a connection parameter, select or create the specific connection that you want the mapping task to use.
•Targets. This page appears only if you defined a parameter for the target connection or object in the mapping. For more information about configuring targets in mapping tasks, click the help icon on this page.
•Runtime Options. Optionally define a schedule for running the mapping task.
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 a connection is selected, you can click Advanced Options to configure the optional advanced properties. For more information about these advanced properties, see Sequential File source properties in mappings.
Note: If the mapping uses a specific source connection and a parameter for the source object, 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 object, select the objects that correspond to the groups you selected in the mapping from the mapping task Sources tab. The number of objects you select must match the number of groups that were added in the multi group data object parameter. To select the source objects, click Select.
By default, the objects are associated with the groups in the order in which the objects appear in the selection window. From the Group Map area, you can change the group to object association by using drag and drop to associate a group with an object.
When you finish entering information on the Sources page, click Validate to validate your entries.
Note: 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 Validate the mapping task again.