What are the built-in performance optimization techniques to use during ETL processing?
PL/SQL Bulk Processing: OWB uses PL/SQL bulk processing for reads and writes. Bulk processing improves the performance of SQL statements that affect multiple rows of data. This feature increases loading performance by approximately five times. Foreign Key Constraint Manipulation: For pure insert operations, OWB goes directly to the Oracle8i database by issuing a single insert statement. This fastest method of inserting data is called batch insert. During batch inserts, OWB intelligently manipulates foreign key constraints so that rows are inserted faster while still preserving referential integrity. This feature results in an approximately threefold performance increase during loading. Users can switch this behavior on and off. Faster Loading from Remote Tables Using the Inline View Technique: OWB automatically detects the common scenario where one or more custom transformations are applied to multiple, joined tables that are located in a remote database. This scenario is most efficien
