rooug iunie 20131 bucuresti, 26 iunie 2013. agenda inregistrarea participantilor odi – common use...
Post on 18-Jan-2018
220 Views
Preview:
DESCRIPTION
TRANSCRIPT
RoOUG
Iunie 2013 1
Bucuresti, 26 Iunie 2013
Agenda• Inregistrarea participantilor • ODI – Common Use Cases
2Iunie 2013
Inregistrarea participantilor
3Iunie 2013
Workshop Oracle Data Integrator
Common Use Cases
Aprilie 2012 4
ETL experience before ODI- SQL - Data Extraction from source- Data Transformations- Data Loading to target
Aprilie 2012 5
ODI connects variated technologies- the tables (data stores) from the same schema / user are grouped within the same data model- each model refers to a logical schema- the logical schema is linked to physical schemas through different contexts- the physical schema are defined related to the data server
6Iunie 2013
The interface is the basic ETL tool- it joins several data store sources - it is usually affecting only one target data store, usually through the insert- it is controlled through Knowledge Modules: Check CKM, Integrating(IKM) / Loading(LKM), Journalisation (JKM)
7Iunie 2013
Several interfaces and other objects are grouped through a flow into a package.
The scenario is the snapshot for the sequence of queries generated for a specific interface, package ( and other objects ) at a specific moment in time.
8Iunie 2013
Several scenarios are grouped through a load plan into parallel or serial executions.
A load plan can be scheduled to start at a specific moment in time.
9Iunie 2013
Data lineage - report on the entire flow of the data up to the target table
10Iunie 2013
Intrebari
11Iunie 2013
top related