View in EDS

SAS Global Forum 2009 Data Integration

Saved in:
Bibliographic Details
Title: SAS Global Forum 2009 Data Integration
Authors: How Leverage, Oracle Bulk-load Performance
Contributors: The Pennsylvania State University CiteSeerX Archives
Source: http://support.sas.com/resources/papers/proceedings09/099-2009.pdf.
Collection: CiteSeerX
Subject Terms: SQL*Loader
Description: Often times, we need to load a large volume of SAS ® data into an Oracle database. Bulk-load through the SAS/ACCESS ® interface would be the first choice in many cases, but there’s a cost associated with dumping SAS data to a text file to accommodate SQL*Loader. SAS V9 further boosts the bulk load by leveraging native Oracle features on load. However, it is crucial to understand how and when to use those functions in order to optimize load for performance. Inappropriate uses of those options may not produce a desired result. Instead, it might jeopardize your load. This paper is intended to explore some of these new features and to discuss the various situations that should be taken into consideration when applying those options in Oracle bulk load. Sample code will be presented to elaborate the benefits gained by appropriate uses of those options, including OR_PARTITION
Document Type: text
File Description: application/pdf
Language: English
Relation: http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.176.1345
Availability: http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.176.1345
http://support.sas.com/resources/papers/proceedings09/099-2009.pdf
Rights: Metadata may be used without restrictions as long as the oai identifier remains attached to it.
Accession Number: edsbas.DEECDD5C
Database: BASE
Description
Abstract:Often times, we need to load a large volume of SAS ® data into an Oracle database. Bulk-load through the SAS/ACCESS ® interface would be the first choice in many cases, but there’s a cost associated with dumping SAS data to a text file to accommodate SQL*Loader. SAS V9 further boosts the bulk load by leveraging native Oracle features on load. However, it is crucial to understand how and when to use those functions in order to optimize load for performance. Inappropriate uses of those options may not produce a desired result. Instead, it might jeopardize your load. This paper is intended to explore some of these new features and to discuss the various situations that should be taken into consideration when applying those options in Oracle bulk load. Sample code will be presented to elaborate the benefits gained by appropriate uses of those options, including OR_PARTITION