Rittman Mead - Delivered Intelligence

In the introduction to this series of posts, I spoke briefly about data warehouse fault tolerance and the unique challenges resulting from high data volumes combined the batch load window required to create them. I then defined the goal: a layered approach allowing simple errors to be caught early before they turn in to serious [...]

With so much of the blog devoted to OBIEE, OWB and Essbase lately, I felt like it was time to do a few database-related postings. In the past, when I’ve posted database content to the blog, I usually gravitate toward ETL-related features: those that waffle between database administration and ETL development. But this time I’m [...]

In the previous part I outlined the business need for writing our own CDC routines and started to outline some of the issues we would need to resolve. Here I shall outline the approach we took and describe how to go about building the SQL needed to synthesise the rows that need to be added [...]

In this posting, I explained the Transcend product as a new offering here at Rittman Mead, and I went on to demonstrate it’s use with index maintenance. Now, I’d like to demonstrate another staple of data warehouse load routines: constraint maintenance.
I constructed a complete replica of the SH schema called SH_NEW for use in this [...]

Before joining up with the guys across the pond, I ran my own consulting company based in Atlanta called Transcendent Data. With each new data warehouse I built, I realized I was engineering the same processes over and over again with each client. So I developed a framework of best-practices for ETL development, encompassing such [...]