The Oracle Bulk Table Loader transformation can be
added to a process flow to take large amounts of data from a SAS or
Oracle source file and bulk load it to an Oracle target.
The Oracle Bulk Table
Loader contains several tabs to define the bulk loading method to
use. The
Load Technique tab and
Table Options tab are specific to Oracle. Other loader
options can be set in the
tab.
The Oracle Bulk Table
Loader functions like other loaders, but it also provides additional
options available on the
Load Technique tab
that allows users to select the best method to load their data. The
default bulk load method is Insert, and other options include Append,
Replace, and Truncate. Other options on this tab allow users to drop
and recreate indexes and constraints and to gather table statistics
after the table has been bulk loaded.
In order for the Oracle
Bulk Table Loader functionality to work properly, follow these data
and configuration considerations:
-
Oracle does not support table names
with spaces in the name, so any table created in metadata with this
name will not load properly.
-
When dropping or creating indexes,
it is expected that these indexes are unique to the target table.
The indexes cannot be used on any other table without causing a collision,
which results in a failure when trying to create those indexes since
the index already exists in the database.
-
The SQL loader must be installed
as part of the Oracle client.