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

Changing the case sensitivity for code generation

Some databases are case sensitive while others are not. Some give you the flexibility to choose whether you want case sensitive table names and column names. Enclosing object names in quotes will ensure that the Oracle database, for one, enforces the case sensitivity. Since the Oracle database gives us this flexibility, we will use it to illustrate how ODI can also enforce case sensitivity by using double quotes around object names.

Getting ready

For this recipe, we will use the DEMO_SRC schema that is described in the Preface of this book. If you haven't done so in an earlier recipe, make sure to create a model in the designer that points to the database's DEMO_SRC schema.

How to do it...

  1. Connect ...

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