Bulk Loader opition (API Vs File Option)

dataservices job design
1

Hi

We are using Oracle 10g as a DWH environment. To Load a file into a database which one would be the better option API or File option (SQL Loader). In which scnerio File option (SQL Loader) performs well?

Regards
ssrinimani

ssrinimani (BOB member since 2009-05-09)

2

None. File-Bulkloader is always slower than the regular loader or the API bulkloader as it has to create a file and sqlloader reads it then. DI uses the same loader techniques as the sqlloader utility internally so is equally fast. Again no reason to use the file bulkloader. The only reasons the option still exists is for debugging and backward compatibility.

Werner Daehn :de: (BOB member since 2004-12-17)