Architectures (ETL/ELT)

ELT (Extract Loading  And Transformation)

ETL(Extarct Transformation And Loading)

Oracle Data Integrator (ODI) is an E‐LT (Extract, Load and Transform) tool used for high‐speed data movement between disparate systems.

•

ODI is based on metadata .This metadata is stored in a centralized metadata repository

Metadata means data about data. In other words it describes the information system and its contents

It provides faster approach for integration.

So that  ODI is simpler and faster integration.

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.