O'Reilly logo

Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial by Peter C. Boyd-Bowman, Bernard Wheeler, David Hecksel

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

Examining ODI Interfaces

Having had a look at data flows and the roles that KMs play within them, let's now dig a bit deeper into the make-up of the primary data flow component—an interface.

The interface component in ODI defines the following data flow properties:

  • The destination datastore for the data (the target). This will be chosen from an ODI model.
  • The datastores that supply the input data (the sources). These too will be chosen from ODI models.
  • The transformations that are applied to the data during the transition from sources to target (the mappings). These are expressed in SQL.
  • The physical transfer mechanisms that are used between sources and target (the flow). We have already seen that this role is performed by the Knowledge Modules.

The ...

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