Working with the Session task and basic properties

Before we can execute the workflow and make the data flow from Source to Target in mapping, we need to configure some basic properties in the Session task. These properties enable the Session task to pick the data from the source and load the data in the target.

Mapping is only a structural representation of the source and target requirement, the actual data movement happens with the properties that we define in the Session task.

To define the properties, perform the following steps:

  1. In the Workflow Manager, open the workflow containing the Session task. Double-click on the Session task, click on Mapping, and click on Source:
    • The Mapping tab of the Session task lets you define the ...

Get Learning Informatica PowerCenter 10.x - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.