Download Oracle Warehouse Builder User's Guide

Best Practices for Designing SQL*Loader Mappings
Figure 9–12 Completed Mapping from Master-Detail Flat File with a Direct Path Load
11. Configure the mapping with the following parameters:
Direct Mode: True
Errors Allowed: 0
Trailing Nullcols: True (for each table)
12. After you validate the mapping and generate the SQL*Loader script, create a
post-update PL/SQL procedure and add it to the Warehouse Builder library.
13. Run the SQL*Loader script.
14. Execute an UPDATE SQL statement by running a PL/SQL post-update procedure
or manually executing a script.
The following is an example of the generated SQL*Loader control file script:
OPTIONS ( DIRECT=TRUE,PARALLEL=FALSE, ERRORS=0, BINDSIZE=50000, ROWS=200,
READSIZE=65536)
LOAD DATA
CHARACTERSET WE8MSWIN1252
INFILE 'g:\FFAS\DMR2.dat'
READBUFFERS 4
INTO TABLE "MATER_TABLE"
APPEND
REENABLE DISABLED_CONSTRAINTS
WHEN
"REC_TYPE"='P'
FIELDS
TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
Understanding Performance and Advanced ETL Concepts 9-21