One of the prime criteria when evaluating an ETL tool is performance of the data load. The speed of the code generated from Warehouse Builder is undisputed in this arena.

Warehouse Builder's unique architecture generates code that runs in the target Oracle9i database. The generated set-based code guarantees the highest performance. Also, data can be directly inserted rather than spending precious network bandwidth to move data around.

Another reason for the unrivalled performance is the close alignment of Warehouse Builder with it’s transformation engine. The Oracle database has specialized functionality available to implement the most scalable and best performing ETL environment. These constructs are used in the code that is generated by Warehouse Builder

Download Mapping feature brief