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.

Note

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 properties for Sources and Targets.
  • Let's discuss the options in detail:
  • Readers: As we are using the Oracle table as our source, the property is mentioned as Relational Reader. It signifies that our source is Table from where we extract the data. If our source...