Exercise 1: Building the Load_Customer interface
The rest of this chapter assumes that we have the infrastructure described previously. You can adapt the system names, user names, and table names in your own environment as you see fit.
We'll complete this exercise in a number of sections as follows:
- Building the topology: To map the physical data resources and show how to connect to them to the Logical Schemas
- Reverse-engineering the model metadata: To translate those physical resources into location-independent representations (Logical Schemas) that will be used in ODI to build data integration objects and workflows
- Moving the data with an ODI interface: To construct and execute an interface that will perform the transformation mappings and data ...