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