What is ODI ? ODI stands for Oracle Data Integrator. it is used as ETL tool. Oracle Data Integrator is […]
Category: ODI
E-LT vs ETL
ETL Stands for Extract, Transform and Load Here, data is first extracted from various sources, transformed in a proprietary middle-tier […]
ODI Architecture
ODI Studio There are four Major component of ODI — Designer — Operator — Topology and — Security. ODI Studio […]
ODI 12C Installation Step
Step 1:Down Load Oracle data integrator 12c from below link. Download ODI 12 C step 2: download both zip file […]
Repository Creation
How to create Master and work Repository. Step 1: open your ODI installation path C:\OracleProduct\Middleware\ODI\oracle_common\bin and run rcu.bat file Step […]
Topology in ODI
Topology in ODI: This layer act as your information system. it is used to manage infrastructure of your information system […]
Table to Table Mapping
1. ODI Component Designer: In this layer we defines rules for data transformation and data integrity. Purpose of this layer […]
Knowledge Module
Knowledge Module • Knowledge Modules (KMs) are code templates. • This Code written using java or python language. • Each […]
File to Table Mapping
File to table Mapping using ODI Step 1: Right click on file technology and select New data server Step 2:Give […]
Variable in ODI
Variable Variable used to store data. At a time you can store only one value. Variable value can be String,Number […]