Data Management Investigate

Oracle Warehouse Builder Tips and Tricks: Advanced Data Transformations

Download now Free registration required

Executive Summary

Oracle Warehouse Builder 11g, the tenth major release of OWB, delivers a rich ETL, data warehousing and data quality feature set that enhances productivity and contributes to project success while lowering total cost of ownership compared to non-Oracle products. This whitepaper looks at advanced data transformation capabilities of Oracle Warehouse that offer compelling value in particular use cases: matching and merging of data, pivoting and unpivoting transformations, advanced aggregation, and DML error logging for advanced error handling. As in any tips and tricks paper, the focus here is on practical applications of the feature set.

  • Format: PDF
  • Size: 624.3 KB