Oracle Data Integrator is built to pushdown the transformation work to the source or target datasource. This means there is no need for a middle tier ETL engine to perform transformations, as many of the traditional ETL tools employ. In fact, in most implementations the ODI agent, which performs orchestration of the ETL processes, simply sends the code to the target server to be executed. This architecture allows ODI to use the power of the target datasource to execute the transformations.
Oracle Data Integrator training provides foundational knowledge and skills to implement data integration processes in business intelligence platforms. It covers basic concepts including data integration, architecture, ODI repositories, and advanced concepts such as ODI project development, etc., and this also will help you become a certified ODI developer.