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 […]
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 […]
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 […]
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 […]
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 […]
