Jim Raper Oracle Quotations

Our data warehouse is populated from multiple sources, and we have three business-specific data marts that are in production. We picked Oracle Warehouse Builder for our ETL tool and Oracle as the database for our central data warehouse for both technical and cost reasons. In our evaluation testing, the total ETL throughput rate, using Oracle Warehouse Builder and an Oracle target, exceeded our minimum requirements by a factor of 10.

We have a very open architecture for data warehousing and BI, partly because Oracle Warehouse Builder 10 g works so well with third-party databases. Oracle Warehouse Builder performs the heavy lifting with our ETL processes, and it minimizes costs by delivering data to a variety of end-user tools.

This new version of Oracle Warehouse Builder will help us scope out the transformation requirements up front, such as how much data cleansing we will have to do and what kinds of transformations will be required. This will allow us to accurately estimate how much work will be involved in pulling new data sources into the data warehouse.