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

Impacting the data flow by changing the staging area location

When an interface is created, ODI will by default create the staging area on the target server. There are many reasons for this design choice:

  • Data is usually loaded into servers that are larger than the ones data is extracted from: data warehouses for instance will host a lot more data than individual systems, and as a result these systems will tend to offer a lot more processing power.
  • Centralizing data coming from disparate sources is more convenient in a central location. As long as everything has to be loaded on the target system eventually, staging on the target will save us additional data movement.
  • Often times, source systems cannot be used for staging because of restricted permissions ...

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