Rittman Mead - Delivered Intelligence

I am still overseas working on a OWB project for a client. We are now into that final phase of checking everything before we promote the first release to the production system. Each OWB map for the first release is redeployed on the development system and then test data run through the map - we […]

One of the new features in OWB 11g (and back-ported to OWB 10.2.03) is support for DML Error Logging. DML Error Logging is a database feature introduced with Oracle 10gR2 that lets you add a LOG ERRORS clause to your DML statement, so that DML operations that would normally fail due to a constraint violation […]

Recently, I mentioned a quirk in OWB 10.2 with a dimension table target configured as a type 2 slowly changing dimension. We have been working on some load performance problems with straight-forward OWB maps. As part of this investigation we wanted to change some of the hints being used in the mapping; for a start […]

When setting up my new PC was that I should down load the OWB reporting add in for SQL Developer. I used to use this tool in preference to using the web reporting from the repository

I have long been a fan of Raptor, or as it became when it was an official product, SQL Developer. […]

I finally got around to installing Oracle 11g earlier this afternoon, and I was pleasantly surprised to notice that Oracle Warehouse Builder gets installed by default:

For someone like myself who makes most of his living from either consulting in, or training in, Warehouse Builder, this is of course good news as it gets the tool […]

I was at the BIWA conference earlier this week (Tuesday and Wednesday), BIWA is an Oracle user group, which as the name suggests, specialises in Business Intelligence, Warehousing and Analytics, more info can be found here on their website. They are planning to run a yearly conference, plus other events and also a series of […]

At long last, my final data warehouse customer on Oracle 9 is moving on to 10g. It has been a somewhat protracted move as for reasons of vendor support certification we had to adopt a specific order of refreshing their whole technology stack. That’s not to say we have no Oracle 8i customers out there […]

Things have been a bit quiet on the blog recently, as Jon and I have taken a bit of leave and I’ve been working on a couple of articles for Oracle. As well as the articles, Jon and I are also due to present at a number of events between now and the end of […]

The other day I was doing some OWB work for a client. I had done some 60 mappings of the most basic kind, when I noticed that the mapping I had used as the basis (I use copy/paste a lot when working with OWB) had the ‘Maximum number of errors’ runtime parameter set to the […]

I have been putting together some thoughts on Agile Development techniques for a paper for the BIWA event later in the year. I have seen a couple of articles on Agile development notably on the Amis blog, here, in the Oracle space, so thought I would add my tuppence worth.
One of the principles of Agile […]