Oracle Enterprise Data Quality Revisited

Monday, March 10th, 2014 by

Recently I have be working with Oracle Enterprise Data Quality (EDQ) combined with Oracle Data Integrator (ODI), we will tell you more about exactly what we have been doing in another blog, but for now I would like to revisit our earlier EDQ blogs. I am going to keep to the batch ETL paradigm and […]

Introducing Oracle Enterprise Data Quality

Thursday, August 23rd, 2012 by

Visually, BI dashboards and analyses can be impressive and appear to meet the user’s needs, but if the data displayed on the dashboards isn’t reliable or correct then those same users can quickly lose faith in what they contain. Therefore, it’s important that assessing and managing data quality becomes an important part of any BI […]

Geography Hierarchies

Tuesday, May 24th, 2011 by

I have been thinking about address a lot recently, in part it was moving house and all of the 1001 people that need to be notified. In the main, though, it was thoughts inspired by a data warehouse project I am working on. For this DWH people are geo-located by their street address, but for […]

Regular Expressions in OBIEE

Friday, December 18th, 2009 by

When reporting against an OLTP system, in many ways, OBIEE works like an ETL tool, transforming the source system data and presenting it as a star schema. After years of writing ETL code, if there’s one thing I hate to be without, it’s regular expressions. So, when working on a project to map an OLTP […]

Data quality is not a one-off

Wednesday, November 12th, 2008 by

In my Blog post on End-to-end data quality I mentioned the desirability of fixing bad data at source. This certainly attracted comment both here and on other blogs for example One point to keep in mind about fixing bad data on the source; it is just that, fixing DATA. We are not fixing bad applications […]

Website Design & Build: tymedia.co.uk