What is Oracle Data Integrator

• It is a ELT tool
• It is an integration platform. It is used to move and transform information across the Information system servers.
• It is also a development platform. It follows business-rules driven approach and E-LT approach for developing datawarehouses.
• Using business approach the developer can focus his efforts on the business side of integration instead of focusing on the technical aspects.
• ELT means extacting , Loading and then transforming. But the traditional approach like informatica, data stage follows ETL exttracting, transforming and then loading. ODI does not run or execute the integration process by itself. It takes the advantage or help of a process that leverages existing systems.
• ODI approaches ELT which eliminates middle tier server to perform transformations required when moving large volume of data.It improves performance and reduces integration costs.