Chapter 7. Advanced Coding Techniques
This chapter covers:
- Using diagrams to develop and maintain models
- Generating DDL from data models
- Generating interfaces from data models or diagrams
- Creating a temporary interface (subquery)
- Loading data from a SQL query
- Performing a pivot
- Loading data using partition exchange
Introduction
A few of the lesser known features of Oracle Data Integrator involve the use of model diagrams. Having a comprehensive understanding of diagrams not only facilitates the development and maintenance of data models, but it enables developers to accelerate the development of basic interfaces.
The Oracle Data Integrator Graphical User Interface (ODI GUI) provides many features that enable a developer to quickly produce sophisticated ...
Get Oracle Data Integrator 11g Cookbook 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.
