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 definitions, namely, CUSTOMER_MASTER in the Oracle Customer System model and CUSTOMER in the Oracle DataMart model.

We then created a new project and imported the Loading and Integration Knowledge Modules that would be needed to build our interface...