Table of Contents

Search

Data Transformation Getting Started Guide

Data Transformation Getting Started Guide

Step 2. Generate and Run a Workflow

Step 2. Generate and Run a Workflow

Generate a workflow for the mapping in the Designer, then run the workflow in the Workflow Manager.
  1. In the PowerCenter Designer, in the
    Navigator
    , find the mapping that you created. If you do not see the mapping, refresh the repository. To refresh the repository, select the repository, right-click and select
    Disconnect
    , then right-click and select
    Connect
    .
  2. From the
    Navigator
    , drag the mapping into the workspace.
  3. In the workspace, right-click and select
    Generate Workflow
    .
    The
    Create Workflow
    dialog box appears. You can rename the workflow or change other workflow properties.
  4. Click
    Next
    , then
    Next
    , then
    Next
    , then
    OK
    .
    The Designer creates a workflow for the session.
  5. Select the Workflow Designer to switch to the Workflow Designer workspace. In the workspace, find the mapping that you created. To edit the workflow, double-click the workflow.
    The session properties dialog box appears.
  6. If the mapping contained source flat file data objects, to assign the source file to the correct path, for each source flat file perform the following steps:
    1. In the session properties, in the Explorer pane to the left, select the source under the
      Sources
      node.
    2. In the
      Mapping
      tab of the session properties, under the
      Attribute
      column in the
      Properties
      pane, find the
      Source filename
      field. Change the file name property to the actual name of the file itself rather than the name of the flat file data object.
  7. In the Workflow Designer workspace, to start the workflow, right-click the workflow and select
    Start Workflow
    .