Configure a mapping task for a mapping with a IMS source. When you run the mapping task, the IMS records are transmitted to the target.
Note: SQL ELT optimization and Visio templates are not supported for IMS 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. If you defined a source object parameter, select the extraction map for a specific source object. For more information, see Properties for parameterized sources and connections.
•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.
Note: If the mapping uses a specific source connection and a parameter for the source object, you can specify these 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 defined a parameter for the source object in the mapping, you must select a specific source object for the mapping task. After you select a source object, the Preview All Columns button appears under Data Preview. However, you cannot preview data for a source object.
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 tables 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 object are associated with the groups in the order in which the tables appear in the object 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 and then click Next to proceed to the Runtime Options page.
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.