Performant and scalable data loading with Oracle Database 12c (White Paper)

Oracle White Paper
Performant and scalable data loading with Oracle Database 12c

Introduction
The main goal when loading data into a data warehouse, whether it is an initial or incremental load, is often to get the data into the data warehouse in the most performant manner. Oracle Database 12c supports several embedded facilities for loading data including: external tables, SQL*Loader, and Oracle Data Pump. This paper focuses on loading data using the most scalable method for a data warehouse. It is by no means a complete guide for data loading with Oracle.

This paper is divided into four sections; after an overview of the load architecture, each section addresses a key aspect of data loading.

• Data loading with external tables
• Prepare for data loading
• Load the data
• Post-load activities

A lot of data loading scenarios, where some resources have to be reserved for concurrent end user activities while loading, will benefit from this paper as well: by applying the discussed best practices recommendations and scaling down the allocated resources for the data load, concurrent end users should be able to complete their activates with zero impact from the data load.

http://www.oracle.com/technetwork/database/bi-datawarehousing/twp-data-loading-oracle-db-12c-2189777.pdf