What is Master Repository

Master repository stores the information defined by topology manager and security navigator.
 Master Repository stores the following information

1. Security Information: users, profiles, access privileges
 2. Topology information including technologies, Data servers, physical and logical schemas , contexts, agents and languages
 3. ODI versions and objects 

What is Work Repository

Each work repository is attached to a master repository, therefore, information about the physical connection to a work repository is stored in the master repository it is attached to.
Defining a connection to a work repository consists of defining a connection to a master repository, then selecting one of the work repositories attached to this master repository

Work repository should always attached to a master repository.

Work repository stores the information defined in Designer navigator .

It stores the following information:

1. Data models: metadata, constraints, references, data lineage, etc

2. Projects: interfaces, packages, procedures, folders, knowledge modules, etc

3. Scenarios, scheduling information and logs

Work repository contents manged by designer and operator.

Components of Oracle Data Integrator

: “Oracle Data Integrator” comprises of:
– Oracle Data Integrator + Topology Manager + Designer + Operator + Agent
– Oracle Data Quality for Data Integrator
– Oracle Data Profiling

What is E-LT? Or What is the difference between ODI and other ETL Tools?

ANS: E-LT is an innovative approach to extracting, loading and Transforming data. Typically ETL application vendors have relied on costly heavyweight , mid-tier server to perform the transformations required when moving large volumes of data around the enterprise.
ODI delivers unique next-generation, Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs, even across heterogeneous systems by pushing the processing required down to the typically large and powerful database servers already in place within the enterprise.

Explain what is ODI?why is it different from the other ETL tools.

ANS: ODI stands for Oracle Data Integrator. It is different from another ETL tool in a way that it uses E-LT approach as opposed to ETL approach. This approach eliminates the need of the exclusive Transformation Server between the Source and Target Data server. The power of the target data server can be used to transform the data. i.e. The target data server acts as staging area in addition to its role of target database.
while loading the data in the target database (from staging area) the transformation logic is implemented. Also, the use of appropriate CKM (Check Knowldege Module) can be made while doing this to implement data quality requirement

What is Oracle Data Integrator

Oracle acquired SUNOPSIS with its ETL tool called “Sunopsis Data Integrator” and renamed to  Oracle Data Integrator (ODI) is an E-LT (Extract, Load and Transform) tool used for high-speed data movement between disparate systems.
The latest version, Oracle Data Integrator Enterprise Edition (ODI-EE 12c) brings together “Oracle Data Integrator” and “Oracle Warehouse Builder” as separate components of a single product with a single licence

ODI Databases Support

   

•   Oracle
•  Ebs
• Sql server
•  Db2
•  Odbc
•  MS Access
•  Sap bw
• Hyperion
• Derbey
•  Groovy
• Informix
•  JMS Queue
•  Xml
• Excel   etc.
• All most it supports 52 Technologies. That’s why we call ODI as a Integration tool