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:
- 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
Mappingtab 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...
- The