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 ...
Get Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
