Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Creating a mapping task

Creating a mapping task

Define general properties of the task on the
General
page.
  1. To create a mapping task, click
    New
    >
    Tasks
    , and then select
    Mapping Task
    and click
    Create
    .
    If you want to create a mapping task based on a template, open the mapping template in the Mapping Designer and then click
    Actions
    >
    New Mapping Task
    .
    If you create a task based on a template from the
    New
    dialog, the task opens in the mapping task wizard which uses a different user interface. For information about creating a mapping task in the task wizard, see Defining a mapping task.
  2. To edit a
    mapping
    task, on the
    Explore
    page, navigate to the
    mapping
    task. In the row that contains the task, click
    Actions
    and select
    Edit
    .
  3. Configure the following fields:
    Field
    Description
    Name
    Name of the task.
    Task names can contain alphanumeric characters, spaces, and the following special characters: _ . + -
    Maximum length is 100 characters. Task names are not case sensitive.
    Location
    Project or folder in which the task resides.
    If the
    Explore
    page is currently active and a project or folder is selected, the default location for the asset is the selected project or folder. Otherwise, the default location is the location of the most recently saved asset.
    Description
    Description of the task.
    Maximum length is 4000 characters.
    Runtime Environment
    Runtime environment that contains the Secure Agent to run the task.
    In a sub-organization, you can't run a mapping task on a Secure Agent group shared by the parent organization if the task is based on a mapping in SQL ELT mode or advanced mode.
    Mapping
    Mapping associated with the task.
    To select the mapping, click
    Select
    and navigate to the mapping that you want to use.
    To open the mapping, click
    View
    .
  4. Configure the job priority and target duration if the
    mapping
    task is based on a mapping in advanced mode.
    The following table describes the properties:
    Property
    Description
    Job Priority
    Priority to schedule the job. High-priority jobs are scheduled sooner than medium-priority or low-priority jobs.
    Target Duration (seconds)
    Time in seconds to complete the job.
    You can view whether the target duration was met or exceeded when you monitor the job. The actual time to complete the job depends on the
    advanced cluster
    infrastructure and the runtime strategy.
  5. Click
    Next
    .

0 COMMENTS

We’d like to hear from you!