Subselect, derived tables, and subqueries in ODI 11G

Uli Bethke Oracle Data Integrator (ODI)

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes 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 ...

Data Modelling books for the Enterprise Data Warehouse (EDW)

Uli Bethke Data Warehousing Books

In other parts of this series we have had a look at data warehousing books that cover the design and architecture of a business intelligence solution. I have also covered data warehousing books in the world of Oracle and data warehousing and business intelligence books for project management and business analysis. Today we'll discuss data modeling books for building an ...

Comparing Exadata and Netezza TwinFin

Uli Bethke Data Warehouse, Oracle

Comparison between Exadata and Netezza Twin Fin. Ok, it comes from Netezza and as such is biased, but still an interesting read. It is worthwhile to remember though that Exadata is designed for mixed workloads (OLTP and Analytics), which is a key differentiator to any of the other DW appliance vendors. Interesting posts by Curt Monash on this http://www.dbms2.com/2009/09/29/integration-oltp-data-warehousing-exadata-2/ http://www.dbms2.com/2010/01/22/oracle-database-hardware-strategy/ ...

OBIEE 11G: 9 September

Uli Bethke Irish BI SIG

No it's not the fecking release date :-). It's just the next date for the Irish BI SIG to meet. This time round the focus will be on OBIEE and in particular on OBIEE 11G. Matt Harte from Peak Indicators will give a presentation on OBIEE best practice. Chris Hathaway from Oracle will give a presentation on the new features ...