What is Oracle data integrator?

• It is a ELT tool
• It is an integration platform. It moves and transform information across the Information system servers
• It is 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.
• It has a centralized repository since it is based on metadata.
• Metadata means data about data. In other words it describes the information system and its contents. ODI centarl repository is used to store this metadata.
• It provides faster approach for integration.
• Therefore ODI is "simply Faster Integration"