In this chapter we covered most of the basics that will help you become very productive with ODI and took our first step towards implementing our PO processing solution—we populated our data mart with the enriched and transformed source data from our Customer System that met the data mart business requirements.

We began by configuring ODI's view of the physical data architecture for the source and target systems using two data servers, the Physical Schemas that they hold (one with a separate work schema), and linking these Physical Schemas to Logical Schema names via the Global context.

Next we reverse-engineered metadata from those schemas into ODI models and in one case, used selective reverse-engineering. This task resulted in two datastore ...

Get Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.