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 4. Using Variables

The recipes in this chapter will deal with six situations that often arise while building Extract-Load-Transform (ELT) solutions using Oracle Data Integrator:

  • Passing start-up parameters to a scenario using variables
  • Using the table names that run in all contexts using getObjectName
  • Using variables to filter data based on a timestamp
  • Using variables in Knowledge Module (KM) options (and reusing the variables in an interface, package, and so on)
  • Using variables in topology
  • Using variables to control loops inside packages

Introduction

Whether you're an Oracle Data Integrator administrator or developer, there are frequently times when the best solution to a given problem may involve the use of variables. Knowing how to declare, ...

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