O'Reilly logo

Oracle Data Integrator 11g Cookbook by Peter C. Boyd-Bowman, Denis Gray, Christophe Dupupet, Julien Testut

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required