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 to the database using your favorite SQL tool (SQL+, SQL Developer, Toad, and so on) and create the src_custs_lower table in the DEMO_SRC schema as follows (be sure to use double quotes to force the table name into lowercase). We will also add a couple...