Rittman Mead - Delivered Intelligence

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

Shortly after I joined Rittman Mead I wrote a small article on real-time Business Intelligence , there is also a link to it on our “Articles” tab. One of the techniques I mentioned in passing was change data capture, CDC.
Although many people believe that change capture is a technique for real-time or near real-time data [...]