Oracle Loader settings - 23.1

Spectrum Dataflow Designer Guide

Version
23.1
Language
English
Product name
Spectrum Technology Platform
Title
Spectrum Dataflow Designer Guide
First publish date
2007
Last updated
2024-05-09
Published on
2024-05-09T23:01:03.226155
Option Name Description

Connection

Select the database connection you want to use. Your choices vary depending on what connections are defined in the Connection Manager of Spectrum Management Console. If you need to make a new database connection, or modify or delete an existing database connection, click Manage Connections.

If you are adding or modifying a database connection, complete these fields:
Connection name
Enter a name for the connection. The name can be anything you choose.
Database driver
Select the appropriate database type.
Connection options
Specify the host, port, instance, user name, and password to use to connect to the database.
Table/View After selecting a connection, specify the table or view to write to. Click the browse button ([...]) to go to the table or view that you want to use.
Listener

Specify the variable name that is set in the Oracle client tnsnames file. For example, this would be the variable name "DB1", that was set in step 3 example.

Stage fields This column lists the field names used in the dataflow. You cannot modify these field names.
Types This column lists the data type of each field.

Runtime Tab

Option Name Description
Load method Specifies how you want to write data into the Oracle database.
Append
Adds the data into the target table without erasing the table's existing data.
Insert
Loads the data into the database. The table must be empty before it is loaded. It doesn't work on multiple runtime instances.
Truncate and Insert
Deletes existing rows if any, then loads the input data into the table. This does not work on multiple runtime instances.
Use direct path loader Select this to load data directly into the Oracle database bypassing much of the data processing that normally takes place.
Unrecoverable This check box is enabled when you select Use direct path loader. Select this if you do not want to write Redo logs in the database. For more information about Redo logs, see What Is the Redo Log? in the Oracle Database Administrator's Guide.
Log file folder Specifies the path to the folder. Click the ellipses button (...) to browse to the folder you want. The log file contains a record of this stage's activities during a load session.
Bad file folder Specifies the path to the folder. Click the ellipses button (...) to browse to the folder you want. The bad file contains a list of records that the stage fails to load into the database.
Maximum errors allowed Specify the maximum number of errors to allow before halting the load operation. To halt the load operation on the first error, set value to 0. A maximum of 32767 errors are allowed.
Note: You can achieve significant performance improvements by using multiple runtime instances of this operation. To do this, click the Runtime button and enter the required value in the Runtime instances field.