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 complete one of the following steps:
    • To create a
      mapping
      task based on a mapping, select
      Mapping Task
      and click
      Create
      .
    • To create a
      mapping
      task using a template, expand the appropriate template category, select the template you want to use, and then click
      Create
      .
  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
    .

Back to Top

0 COMMENTS

We’d like to hear from you!