Database Reference
In-Depth Information
Let's discuss the options in detail:
•
Writers
: As we are using the Oracle table as the target, the property is mentioned
as a relational writer. This signifies that our target is the table where we wish to
load the data. If we use target as flat file, the property will change to
File Writer
.
•
Connection
: Assign
Target Connection
for the database, as shown in the preced-
ing screenshot. If your target is
File
, the
Connections
option will be disabled, as
we need not define the connection for files.
•
Properties
: The target load type is a very important aspect while loading the data.
The target load type is of two types:
Normal
and
Bulk
. Selecting the property as
bulk allows faster loading into the target. You cannot use the property as bulk if