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 on the
Options tab.
The Oracle Bulk Table
Loader functions like other loaders, but it also provides additional
options available on the
Load Technique tab.
These options enable 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. Additional options on the
Load
Technique 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 an index is dropped or created,
the index must be unique to the target table. The index cannot be
used on any other table without causing a failure when trying to create
the index because the index already exists in the database.
-
The SQL loader must be installed
as part of the Oracle client.