Loading data to Oracle

These are the properties that can be set to customize the bulk load operation when the stage is configured for the Oracle database type.

Schema name

Specifies the name of the schema (owner) in which the target table resides.

There is no default value.

If no value is specified the table is assumed to reside in the schema of the currently connected user.

Partition name

Specifies the name of the table partition to which to load data.

There is no default value.

If the value is not specified, the data is loaded to the entire table.

Max Record Number

Specifies the maximum number of input records in a batch.

The default value is 100.

Load mode

Specifies the method to use to load the data in the target table.

The supported values are:

Automatic: Loads the data directly to the target database table using Direct Path Oracle interface.
Manual: Creates Oracle SQL*Loader control file and data file which can later be used to perform the load with Oracle SQL*Loader utility.

Control file name

Specifies the name of the Oracle SQL*Loader control file that the stage creates when the Load mode property is set to value Manual.

There is no default value.

Data file name

Specifies the name of the Oracle SQL*Loader data file that the stage creates when the Load mode property is set to Manual.

There is no default value.

Delimiter

Specifies the character used to delimit field values in the input data.

The default values is comma character ( ,).

Preserve Blanks

Specifies whether to preserve trailing blanks in the input text values or to truncate them.

The supported values are:

Yes: Preserve the trailing blanks.; This value is the default value.
No: Truncate trailing blanks.

Case sensitive column names

Specifies whether the input link column names should be treated as case sensitive values.

The supported values are:

Yes: The column names should be treated as case-sensitive values.
No: All characters in the input link column names should be treated as uppercase characters.; This value is the default value.

In the manual load mode the stage does not write data to the database table directly, but instead creates Oracle SQL*Loader control and data files to be used with Oracle SQL*Loader to load the data to the table. The format of these two files is determined internally by the stage and can change in future releases of the product. For this reason it is not recommended to design jobs that rely on the current format of these files.

If the control file name is not specified, the stage will create the control file name consisting of the specified Oracle service name, followed by the underscore character, followed by the specified name of the table to which the data is loaded, followed by the .ctl extension.

If the data file name is not specified the stage will use the same logic to produce the data file name except instead of the .ctl extension, the .dat extension will be used for the file name.