Entries from Oracle Warehouse Builder (OWB) Weblog tagged with 'ODI'

OWB 11gR2 - Subquery

One of the new mapping operators introduced in 11gR2 is the much talked about (over the years) subquery filter operator. As well as the heterogeneous capabilities added, a number of enhancements to existing operators (such as joiner and lookup operator)...

OWB 11gR2 – Template mapping variables?

Here we'll see how you can add runtime variables and reference them from code template mappings in OWB 11gR2; variables can be used in many places including expressions, filters, joiners and execution unit code template assignments. This lets you control...

OWB 11gR2 – Cube Organized Materialized Views

Here we will look at building cube organized materialized views for a relational fact table. The illustration uses the Oracle OLAP 11g Sample Schema and rather than the cube organized materialized views being created via the script in the demo,...

OWB 11gR2 – Trickle Feed Data Acquisition and Delivery

The OWB 11gR2 release introduced near real time data warehousing capabilities. OWB has been enhanced to also support a continuous trickle feed loading approach by introducing the concept of trickle feed mappings. A trickle feed mapping is a mapping with...

Data Integration at Oracle Open World 2009

Open World 2009 is almost upon us. For those thinking about attending, there's a schedule of events and product demos around data integration on OTN, here: http://www.oracle.com/technology/products/oracle-data-integrator/events/data_integration_openworld-2009.html This page will be updated on an ongoing basis as we get closer...

Oracle Warehouse Builder 11gR2

Great news, today Oracle released the Linux x86 and x86-64 versions of 11gR2 for the Oracle Database which includes Warehouse Builder (see Oracle Database 11gR2 here). Nice to finally see all the hard work eventually come to fruition. This has...