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