Roelant Vos An expert view on Agile Data Warehousing

Types of errors 0

Types of errors

 

 There are two main categories of errors: technical errors and business rule errors (functional). Both types of errors should be classified separately because both provide different information about the nature of the error. A few examples are listed here:  –          Technical errors: invalid data type conversion, duplicate insert, unable to delete or move files or missing primary or foreign keys –          Functional errors: ‘the sum of attribute A and B does not equal C’ or...

Ideas for general error handling, why need error tables? 3

Ideas for general error handling, why need error tables?

 

 The possible scenarios regarding error and exception handling are limited. You can either: –          Detect an error, stop the process and present the error code. –          Detect an error and write the record in an error table with the corresponding  code. –          Detect an error and write the record in both the target and the error table with the error code. –          Detect an error, flag the record but write it to the DWH table...

A plea against IT abbreviations and upper-casing 0

A plea against IT abbreviations and upper-casing

 

 Every project I have worked on there is an abundance in abbreviations used for almost anything, from project names (codes) to mappings, (source) systems, workflows, team member names and database attributes. Even worse, the meaning of these abbreviations is lost or vague and in some cases even wrong (because the ‘real’ abbreviation is already taken)! Every time I feel it makes it so much harder for new team members to grasp the meaning of the system and/or...