Oracle Data Integrator 11g Cookbook

Foreword

In 1998, when Sunopsis first opened its door to begin development of the product that would become ODI, the technology landscape was very different from today. There were very few data warehouses over 10 terabytes, and both the underlying hardware and software were struggling to keep up with the load and query demands placed upon them. As a result, the warehouses only included the most critical transactional data from the few key systems. The prevailing ETL approach of the day was to hand-build highly optimized flows, which executed in dedicated hardware, and then spoon-feed the results into the data warehouse. In this context, the founding principles of ODI were extraordinarily bold: leverage the data warehouse itself as the transformation ...