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 flow operations and populate our target table in the data mart
Checking the execution with Operator console: To view the execution status and check the number of rows integrated, together with viewing some of the code generated and run by ODI
