Since it's usually beneficial to avoid hard-coding fully qualified schema and object names (doing so can create issues when migrating
code between environments), we will often want to employ a simple technique that uses one of the out of the box ODI substitution methods:
odiRef.getObjectName.odiRef.getObjectName. This particular method can resolve and return the complete object name for a specified table depending on the context in which the application is currently running. In this recipe, we will examine some of the details of how ODI can resolve a complete database table name using only a base object name.
All references to tables in this recipe are taken from the data ...