Generate a workflow for the mapping in the Designer, then run the workflow in the Workflow Manager.
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
.
From the
Navigator
, drag the mapping into the workspace.
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.
Click
Next
, then
Next
, then
Next
, then
OK
.
The Designer creates a workflow for the session.
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.
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:
In the session properties, in the Explorer pane to the left, select the source under the
Sources
node.
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.
In the Workflow Designer workspace, to start the workflow, right-click the workflow and select
