Subselect, derived tables, and subqueries in ODI 11G

Uli Bethke Oracle Data Integrator (ODI)

I think one of the best new features in ODI 11G is the subselect/subquery feature. In ODI 10 this could only be achieved by a workaround as outlined in a previous post Using subqueries in Oracle Data Integrator. What is the advantage of a subquery? In previous versions of ODI we had to physically set down the data for each ...