Request Info
Overview Extract Transform Load Flat-File ETL ELT Cleanse Federate MDM Migrate Protect Report



If the fastest place to stage a data warehouse database (DB) is in the file system, what is the fastest way to load them? There are many ways to load DBs, including:

  • single or bulk row inserts
  • create or insert (with append hint) as select from another table
  • conventional and direct path loads

Many DBAs do not know the fastest method, and instead use proprietary DB export/import tools that do not serve heterogeneous data warehouse architectures.



CoSort software in the IRI Data Manager suite or IRI Voracity (ETL) platform can create and populate tables directly with SQL update, truncate, and append functionality.

However, the fastest method for bulk loading DBs like Oracle is through a bulk load pre-sort:

Blog > VLDB Operations > High Speed DB Loading

CoSort rapidly sorts flat files in index order that SQL*Loader, DB2 Load, bcp and similar utilities can load into tables.

CoSort can also transform and report on the data (so the DB does not have to). Having tables in query order, and removing bulk transformation overhead from the DB layer, both improve query performance.

Request More Information

* indicates a required field.
IRI does NOT share your information.