Thoughts on Change Data Capture

Tuesday, March 9th, 2010 by Peter Scott

In little over a month I will be in Las Vegas speaking at Collaborate 10. There is a lot of BI / DW talks this year and for the first time with BIWA Training Days branding. Rittman Mead will be there at the conference giving talks on each of the conference days. If you are [...]

Oracle 11g Pivot

Tuesday, February 23rd, 2010 by Peter Scott

One of the things that I often come across is the “up-dateable fact”, that is a fact that starts life “incomplete” and changes overtime. Examples include things such as support calls that start life as “open” then progress through “responded”, “resolved” and finally “closed”; statuses in the sales cycle such as ordered, paid, shipped; stock [...]

Data Warehouse Fault Tolerance Part 3: Restoring

Friday, February 12th, 2010 by Stewart Bryson

Hopefully you’ve read the introduction, Part 1, and Part 2. Those posts detailed methods for building fault-tolerant ETL code, with a strong bias in favor of using Oracle Database features. Now I’ll drill into the backup and recovery aspect of data warehousing fault tolerance, and tackle the age-old question of whether to ARCHIVELOG or NOARCHIVELOG [...]

Data Warehouse Fault Tolerance Part 2: Restarting

Wednesday, February 10th, 2010 by Stewart Bryson

In my last post, I described the First “R” in data warehouse fault tolerance: Resuming. As I mentioned in the introduction to this series, my goal is a triage approach where the simple things, such as space errors, are handled effortlessly without repercussions. But what happens when the errors are not so simple, and Oracle’s [...]

Data Warehouse Fault Tolerance Part 1: Resuming

Monday, February 8th, 2010 by Stewart Bryson

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

Website Design & Build: tymedia.co.uk