Oracle Data Integrator Enterprise Edition has advanced capabilities like loading slowly changing dimensions, complex data integration process flow logic, re-usable mappings and design-time automation through scripting.
Built-in dimensional modeling tools are included in Oracle Data Integrator to simplify Oracle Data Warehouse Integration.
Oracle Data Integrator ensures automatic detection and recycling of faulty data before insertion in the target application and is performed through data integrity rules and constraints defined both on the target application and in Oracle Data Integrator.
In order to ensure real-time data integration, Oracle Data Integration suite provides all key components required to enable real-time data warehousing and operational data hubs.
Room for Improvement:
As with any big tool, truly mastering ODI may take months.
Oracle Data Integrator separates the declarative rules from the implementation details. It can run entirely within a Service Oriented Architecture. ODI is the most integrated ETL product for running data integration as a service, accessing web services and writing to web services as a target.
Disclosure: I am a real user, and this review is based on my own experience and opinions.
Jan 25 2013