TABLE/CAST/MULTISET vs subquery in FROM clause.One of the new mapping operators introduced in 11gR2 is the much talked about (over the years) subquery filter operator. ODI 12c new features: Dimension and Cubes! Part 4 (Loading using Surrogate Keys) Posted in Dimensions, ETL, ODI 12c, ODI Architecture, ODI Mapping, Oracle, Tips and Tricks with tags Architecture, Dimensions, New Features, ODI 12c, odi interface, Tips and Tricks on Decemby RZGiampaoli Subqueries. Advantage of table function is performance and memory. Drag the filter component from component pallet. Subquery filter in odi 12c Ans: ODI stands for Oracle Data Integrator.
