Database Reference
In-Depth Information
The
Mapping
tab of the session task lets you define the properties for the source and the
target. Let's discuss the options in detail:
•
Readers
: As we are using the Oracle table as our source, the property is men-
tioned as relational reader. This signifies that our source is a table from where we
are extracting the data. If your source is flat file, the property will change to
File
Reader
.
•
Connections
: Assign the connection for the database, as shown in the preceding
screenshot. If your source is
File
, the connections option will be disabled, as we
need not define connections for files. Note that we will be discussing how to add
connection objects later in this chapter.