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

Get Oracle Data Integrator 11g Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.