PowerCenter
- PowerCenter 10.5
- All Products
Attribute
| Default Value
| Description
|
---|---|---|
Error Limit | 1 | Number of errors to allow before the external loader stops the load operation. |
Load Mode | Append | Loading mode the external loader uses to load data. Select one of the following loading modes:
|
Load Method | Use Conventional Path | Method the external loader uses to load data. Select one of the following load methods:
|
Enable Parallel Load | Enable Parallel Load | Determines whether the Oracle external loader loads data in parallel to a partitioned Oracle target table.
|
Rows Per Commit | 10000 | For Conventional Path load method, this attribute specifies the number of rows in the bind array for load operations. For Direct Path load methods, this attribute specifies the number of rows the external loader reads from the target flat file before it saves the data to the database. |
External Loader Executable | sqlload | Name of the external loader executable file. |
Log File Name | n/a | Path and name of the external loader log file. |
Is Staged | Disabled | Method of loading data. Select Is Staged to load data to a flat file staging area before loading to the database. Otherwise, the data is loaded to the database using a named pipe. |