Re-summarise versus fast Mview refresh - part 1

Monday, July 31st, 2006 by Peter Scott

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

Speaking Dates, and Moving to Ubuntu

Saturday, July 29th, 2006 by Mark Rittman

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

Speaking Dates, and Moving to Ubuntu

Saturday, July 29th, 2006 by Mark Rittman

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

Pluggable Mappings using OWB10gR2

Friday, July 28th, 2006 by Mark Rittman

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

Pluggable Mappings using OWB10gR2

Friday, July 28th, 2006 by Mark Rittman

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

End of life

Thursday, July 27th, 2006 by Peter Scott

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

Street Wars Around London

Wednesday, July 26th, 2006 by Mark Rittman

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-summarisation

Sunday, July 23rd, 2006 by Peter Scott

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 weekend hotchpotch or is it hodgepodge?

Saturday, July 22nd, 2006 by Peter Scott

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

Partition Exchange Loading using OWB10gR2

Thursday, July 20th, 2006 by Mark Rittman

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