O'Reilly logo

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial by Peter C. Boyd-Bowman, Bernard Wheeler, David Hecksel

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Summary

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required