Creating a temporary interface (subquery)

During normal application development, there may be times when the complexities of the functional requirements extend beyond the capabilities of a single ODI interface. To address these situations, and with the release of version 11g, ODI allowed temporary interfaces to be used as subqueries. Using a temporary interface allows developers to split up the complex logic into multiple interfaces. While a comprehensive list of use cases is impractical to mention here, this section will provide an example of one of the two basic types of temporary interfaces available:

• Temporary interfaces using persistent data stores (target tables that already exist or will be created within the designated target schema)

• Temporary interfaces using non-persistent data stores (target tables that are not instantiated but will be used to form a subquery within other interfaces)

In this recipe, we will demonstrate the implementation of a non-persistent temporary interface used...