Summary

You should now be starting to feel comfortable with some of the common activities in ODI. After first installing a third-party JDBC driver (MySQL), you were presented with two examples which led us through a series of activities representing many of the most frequently performed tasks within ODI.

Following those examples, we built several topology entries for data servers and physical schemas and linked them to logical schema names via contexts. We then used those logical schemas to reverse-engineer physical, vendor-specific metadata into a logical, platform-independent data model.

We then created a new project folder and imported the specific Knowledge Modules that would be needed based upon the interface requirements. We then built two separate interfaces in order to populate a target from one or more sources linked together either by joins or lookup relationships. We added simple column mappings using both the Automatic Mapping or standard drag-and-drop methods. We also augmented...