Our Toolbox – Essential Software

A data warehouse project will usually involve many pieces of software. These can be broken into two categories – architectural software and supporting tools. The architectural software will include the database, ETL tool, reporting tools, etc.…

Read More

Our Software

Over the years we have produced several utilities and open source projects. List list provides some information about their status GROUT – ETL tool including DAP & SQLUnload written in Korn Shell, C & PL/SQL –…

Read More

Oracle DBA Crib Sheet

Introduction The Oracle DBA Crib Sheet is not an exhastive list of what a DBA has to do, instead it has been written for a particular client whose support team occasionally need dba commands and don’t…

Read More

Basic Data Quality Checks

This article looks at basic data quality audit that can be done within a database. Examples are given using Oracle syntax however the techniques can also be applied to other databases   Introduction The following article…

Read More

Detecting Changed Data

Introduction When loading data warehouses, it is usually possible to decreases the load time very significantly by processing only changes since the last load, rather than completely refreshing all the data every time. This article describes…

Read More