CSV File Format

We all know that we should be writing file extracts as XML but if we really need to get a CSV file then here is how to do it Introduction Comma Separated Values (CSV) files have…

Read More

Building Data Marts

This article descibes building data marts from a data warehouse or transaction repository. It discusses the merits of full and incremental loads for different data marts.   The types of data marts to load Having built…

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