Table of Contents

Search

  1. Preface
  2. Understanding Pipeline Partitioning
  3. Partition Points
  4. Partition Types
  5. Pushdown Optimization
  6. Pushdown Optimization and Transformations
  7. Real-time Processing
  8. Commit Points
  9. Row Error Logging
  10. Workflow Recovery
  11. Stopping and Aborting
  12. Concurrent Workflows
  13. Grid Processing
  14. Load Balancer
  15. Workflow Variables
  16. Parameters and Variables in Sessions
  17. Parameter Files
  18. FastExport
  19. External Loading
  20. FTP
  21. Session Caches
  22. Incremental Aggregation
  23. Session Log Interface
  24. Understanding Buffer Memory
  25. High Precision Data

Advanced Workflow Guide

Advanced Workflow Guide

Configuring Oracle External Loader Attributes

Configuring Oracle External Loader Attributes

The following table describes the attributes for Oracle external loader connections:
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:
  • Append
  • Insert
  • Replace
  • Truncate
Load Method
Use Conventional Path
Method the external loader uses to load data. Select one of the following load methods:
  • Use Conventional Path.
  • Use Direct Path (Recoverable).
  • Use Direct Path (Unrecoverable).
Enable Parallel Load
Enable Parallel Load
Determines whether the Oracle external loader loads data in parallel to a partitioned Oracle target table.
  • Enable Parallel Load to load to partitioned targets.
  • Do Not Enable Parallel Load to load to non-partitioned targets.
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.


Updated June 25, 2020