Materialized View and Partitioning “Gotchas”, Part II

Thursday, June 11th, 2009 by Stewart Bryson

If you follow the blog, then you know that Mark recently posted about materialized views for aggregation, located here.
One of the issues he encountered was how to refresh materialized views based on tables loaded with partition exchanges… a common approach to loading fact tables while minimizing the downtime for the reporting schema. Once the […]

Simple Steps to Sustainable ETL

Thursday, April 30th, 2009 by Peter Scott

Recently Stewart posted his first blog post here on the Rittman Mead Blog, it drew quite a bit of comment about using external techniques to the ETL to provide mechanisms to do things more efficiently or to do things that could not otherwise be done.
Notwithstanding the claims of some DW appliance vendors that you just […]

Using a PARTITION BY JOIN to Fill In The Gaps

Wednesday, April 22nd, 2009 by Stewart Bryson

As a quick introduction, I’m Stewart Bryson, Technical Director for North America. It seems strange to be posting an entry on this blog after so many years of reading it, and learning from it. The momentum it has in the community is something I do not take lightly, so hopefully, this post and others from […]

Analytic Views as OWB Data Source

Tuesday, March 3rd, 2009 by Peter Scott

Readers of my old blog - much now ported here to the Rittman Mead blog may remember my fondness for things SQL (rather than PL/SQL) and analytic functions in particular. It is not that I can’t “do” PL/SQL it is more that I think there is sometimes a better way. Recently, I came across one […]

Comparing ODI and OWB’s Data Profiling and Quality Options

Wednesday, February 11th, 2009 by Mark Rittman

Now that Oracle Data Integrator and Oracle Warehouse Builder are starting to converge, I thought it worth taking a closer look at what’s new with the 10.1.3.4 and 10.1.3.5 releases of ODI. One of the most interesting new features introduced with ODI 10.1.3.4 was new data quality and profiling capabilities, and so given the new […]

Website Design & Build: tymedia.co.uk