Rittman Mead - Delivered Intelligence

Overnight in my email I received a desupport notice for Oracle Warehouse Builders 9.2 and 10.1
One of my customers has DW built on OWB 9.2 and is normally ‘new release adverse’ that if there are no significant problems and it does the job then why upgrade a stable system? But paramount is that desire to [...]

Now this appeals to my sense of humour. This article in today’s Independent talks about a new game called Street Wars, a three-week water pistol assassination game played out around London. When you sign up, you are given the mobile number, name and address of someone you have to ‘assassinate’, and someone else has got [...]

Re-summarization, re-statement or re-summarisation, call it (or spell it) as you will, is a periodic maintenance task in some data warehouses.
Most fact tables contain just the measures and keys to the dimension tables. This design is flexible in that it supports both non-changing and slowly changing dimensions, and for slowly changing dimensions it works with [...]

A while back I wrote about using the row_number() analytic function and analytics in general. At the time I said that I did not use analytics often, perhaps rank() when people wanted to find their top 46789 customers – yes, sometimes they choose very odd numbers :-) This week we put dense_rank to work [...]

In this final posting in the series, I’ll look at how Oracle Warehouse Builder 10.2 can be used to perform Partition Exchange Loading into a target table.
Partition Exchange Loading (PEL) s a data warehousing technique that is useful when you are loading data into a large, partitioned table. By swapping the table that contains the [...]