Oracle Loader
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 Management Console. If you need to make a new database connection, or modify or delete an existing database connection, click Manage. If you are adding or modifying a database connection, complete
these fields:
|
Table/View |
After selecting a connection, specify the table or view to write to. Click the browse button ([...]) to navigate to the table or view that you want to use, or click Create Table to create a new table in the database. Note: If you are writing to a SQL database, you cannot write to
views that reference more than one table. This is due to a
limitation in SQL Server.
|
Listener | Specify a variable name that contains the address and connection details required to establish a connection to the Oracle database. For example, "XE". This variable is present in tnsnames.ora, a file that contains client side network configuration parameters. |
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.
|
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 http://docs.oracle.com/cd/B28359_01/server.111/b28310/onlineredo001.htm#ADMIN11302 |
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. |