What are Knowledge Modules?

Knowledge Modules:

KM are referred as Code Template which helps in overall Data Integration Process with the help of the Metadata from Interface and Models Km Executes Relevent Code Generated by ODI .

There are predefined set of KM which covers almost all the DB types and scenario in ODI .KM are Customizable so no need to fear if there is any KM Missing for DB or Scenario. 

KM are classified in following types

What systems can ODI extract and load data into?

Types Of System ODI can Extract:

Man ODI can handle a lot of system which you would have never thought of.

As the Matter of Fact ODI has ability to connect to More than 30+ DB.

Its True ODI has out of Box Heterogeneous Connectivity to Many Important DB listed below..

What is Oracle Data Integration Suite?

Oracle Data Integration Suite (ODI Suite) is a collection of Oracle's Best data integration technologies. ODI Suite enables enterprise data architects to unify, manage, and distribute data into enterprise applications.

Important data integration services are:

• Data distribution and delivery
• Data transformation and migration
• Master data management, work-flow and governance

Components

ODI Suite has the following components:

• Oracle Data Integrator (ODI)
• Oracle Data Relationship Management
• Oracle Data Quality and Data Profilerfor Data Integrator
• Oracle BPEL Process Manager
• Oracle Service Bus(OSB)
• Oracle Application Server Enterprise Edition
• Oracle Coherence In-Memory Data Grid
• Oracle Integration Adapters 

  For Further Reference:

ODI SUITE PDF :
www.oracle.com/us/products/middleware/059491.pdf‎

ETL VS ELT

what is the difference between ETL and ELT ?

ETL 
The transformations are processed by the ETL tools (Informatica , Datastage etc) while in ELT the transformations are processed by the target datasources (RDBMS). I guess that the rising scalability of databases allows this kind of data integration to be possible.
So the important thing to remember is the side where the transformations are processed.
I made the following schema to help remember the difference :

ELT 

What Is Oracle Data Integrator (ODI) ?

Oracle Data Integrator (ODI):

 Oracle’s ELT tool, is a unique next-generation, Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs even across heterogeneous systems. It can be used to extract data from a variety of data sources (relational databases, flat files, etc.), perform complex data transformations, and load data into a variety of target data stores (data warehouses, application databases, flat files, etc.).  ODI can be used to support a variety of data integration projects, including the following:

•     Business Intelligence and Data Warehousing
•     Data Migrations and Data Consolidations
•     Master Data Management

Oracle Data Integrator Download

ODI can be downloaded directly from Oracle’s website.  Follow the link below for a free trial download of ODI.  Be cautious these available links below are not to be used in Production Environment.

•     Oracle Data Integration Downloads
•     Oracle Software Delivery Cloud

ODI Resources

 Oracle’s ODI page is the first page where u can find Loads of DATA on ODI features, Getting started guides, and ODI documentation.

If you have a any doubts about ODI, or if you want to acquaintance with other fellow ODI developers, check out the Oracle forums.

Another good resource is the official Oracle Data Integrator Blog.