Rittman Mead - Delivered Intelligence

A couple of days ago I wrote that we may need re-build summary tables when items change parents. More exactly, it is the tables at the parent level (and above) that need to be refreshed when the parents adopt new offspring
The items that have changed parentage could well be dotted throughout the whole table, and […]

Like Doug and Alex, I got my acceptance email through from the UKOUG yesterday saying that my two papers had been accepted for the conference in November. I know most of you probably thought I picked the papers in the BI track anyway, but this year I couldn’t make it to the paper selection day […]

Like Doug
and Alex,
I got my acceptance email through from the UKOUG yesterday saying that
my two papers had been accepted for the conference in November.
I know most of you probably thought I picked the papers in the BI track
anyway, but this year I couldn’t make it to the paper selection day so
I genuinely didn’t know until […]

In this posting I’ll look at how pluggable mappings are used in Oracle Warehouse Builder 10gR2.
Pluggable Mappings are a good way of creating reusable ETL components that can be dropped into a mapping. A pluggable mapping consists of in and out interfaces, and a set of OWB mapping steps that retrieves a value, updates an […]

In this posting I’ll look at how pluggable mappings are used in Oracle
Warehouse Builder 10gR2.
Pluggable Mappings are a good way of creating reusable ETL components that
can be dropped into a mapping. A pluggable mapping consists of in and out
interfaces, and a set of OWB mapping steps that retrieves a value, updates an
object or some other […]

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