OWB map testing

Saturday, February 16th, 2008 by Peter Scott

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

OWB11g, DML Error Logging and Data Rules

Thursday, January 31st, 2008 by Mark Rittman

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

OWB quirkiness

Monday, January 14th, 2008 by Peter Scott

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

Another thing I forgot…

Saturday, November 24th, 2007 by Peter Scott

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

A First Look at OWB11gR1

Friday, November 9th, 2007 by Mark Rittman

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

More on BIWA

Friday, October 5th, 2007 by Jon Mead

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

Upgrading to 10g - OK, I’m a bit behind

Friday, August 31st, 2007 by Peter Scott

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

Open World, BIWA, UKOUG and Oracle Mag

Wednesday, August 15th, 2007 by Mark Rittman

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

A little bit of OMB+ goes a long way

Monday, July 9th, 2007 by Borkur Steingrimsson

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

Smoke Testing with OWB

Friday, June 22nd, 2007 by Jon Mead

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