Configure a mapping task for a mapping with an IDMS source. When you run the mapping task, the IDMS records are transmitted to the target.
Note: SQL ELT optimization and Visio templates are not supported for IDMS 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:
•Definition. 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. 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. You can also define email notification options and some Advanced options such as Pre-Processing Commands, Post-Processing Commands, and Maximum Number of Log Files.
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 IDMS source properties in mappings.
Note: 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 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 table 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 a 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.
Running a mapping task
A mapping task runs on-premises under control of the Secure Agent.
To run the mapping task, use any of the following methods:
•After you finish configuring the mapping task, click Run.
•Manually start the mapping task from the Actions menu on the Explore page.
•Create a schedule that runs the mapping task based on a date, time, and repeat frequency, such as hourly, daily, weekly, or monthly.
•Include the mapping task in a taskflow and then run the taskflow.
Monitoring a mapping task
After you run a mapping task, you can check the job status for the task to determine if the job succeeded, completed with warnings, or failed. If the job failed or ended with a warning, you can view the session log for the job to identify the error or warning conditions.
Each time a user or schedule starts a mapping task, Informatica Intelligent Cloud Services creates a job to run the task.
1To view a list of mapping task jobs, use one of the following methods:
- In Data Integration, select My Jobs. The My Jobs page lists all jobs that you, the user who is currently logged in, started. It does not include jobs that were started by a schedule.
- In Monitor, select All Jobs or Running Jobs. The All Jobs page lists all of the running and completed jobs that members of your organization started or that were started by a schedule. The Running Jobs page lists only the jobs that are currently running or that have completed within the last 5 minutes.
2On the My Jobs, All Jobs, or Running Jobs page, review the information about the jobs you're interested in. The following information is displayed by default and shown for each job instance:
- Start date and time
- End date and time
- Number of rows processed
- Current status, which can be one of the following values: Queued, Starting, Running, Success, Stopped, Suspended, Warning, or Failed.
Tip: You can change the columns that are displayed by right-clicking the column-heading area and selecting or deselecting column names in the list.
For more information about a job, click the job name to open a page that contains job details and a download link for the session log. You can also download the session log by moving the cursor to the right end of the row for a job and clicking the Download Log icon.
3If the job status is Failed or Warning, gather more information about the error or warning condition in the following ways:
- For a Failed job, hover the cursor over the Failed icon in the Status column. A brief description of the error condition appears, which you can copy.
- Download the session log and look for error or warning messages that begin with the message ID prefix of "PWXPC" or "PWX."
If possible, correct the error or warning condition and then restart the job. To restart the job from the Jobs or My Jobs page, move the cursor to the right end of the row for the job and click the Restart icon.