1 / 11

RoOUG

RoOUG. Bucuresti, 26 Iunie 2013. Iunie 2013. 1. Agenda. Inregistrarea participantilor ODI – Common Use Cases. Iunie 2013. 2. Inregistrarea participantilor. Iunie 2013. 3. Workshop Oracle Data Integrator Common Use Cases. Aprilie 2012. 4.

hadassah-rivas
Download Presentation

RoOUG

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. RoOUG Bucuresti, 26 Iunie 2013 Iunie 2013 1

  2. Agenda • Inregistrarea participantilor • ODI – Common Use Cases Iunie 2013 2

  3. Inregistrarea participantilor Iunie 2013 3

  4. Workshop Oracle Data IntegratorCommon Use Cases Aprilie 2012 4

  5. ETL experience before ODI- SQL - Data Extraction from source- Data Transformations- Data Loading to target Aprilie 2012 5

  6. 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 Iunie 2013 6

  7. 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) Iunie 2013 7

  8. 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. Iunie 2013 8

  9. 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. Iunie 2013 9

  10. Data lineage - report on the entire flow of the data up to the target table Iunie 2013 10

  11. Intrebari Iunie 2013 11

More Related