Academic Journal
SAS Global Forum 2009 Data Integration
| Τίτλος: | SAS Global Forum 2009 Data Integration |
|---|---|
| Συγγραφείς: | How Leverage, Oracle Bulk-load Performance |
| Συνεισφορές: | The Pennsylvania State University CiteSeerX Archives |
| Πηγή: | http://support.sas.com/resources/papers/proceedings09/099-2009.pdf. |
| Συλλογή: | CiteSeerX |
| Θεματικοί όροι: | SQL*Loader |
| Περιγραφή: | 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 |
| Τύπος εγγράφου: | text |
| Περιγραφή αρχείου: | application/pdf |
| Γλώσσα: | English |
| Relation: | http://citeseerx.ist.psu.edu/viewdoc/summary?doi=10.1.1.176.1345 |
| Διαθεσιμότητα: | 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. |
| Αριθμός Καταχώρησης: | edsbas.DEECDD5C |
| Βάση Δεδομένων: | BASE |
| Η περιγραφή δεν είναι διαθέσιμη |