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

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

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

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

Website Design & Build: tymedia.co.uk