The ETL Generator - A Holy Grail (or is it?)
For some reason I can’t quite fathom myself either, I spend considerable amounts of time in all manner of datawarehouse / ETL related product development groups. (A substantial bit of that time, I should add, being my own; major system integrators put great value in R&D - just as long as it doesn’t eat into the billable hours.) And whether they […]
Testing ETL or: Some More Fun with the Informatica Repository
Family and friends sometimes ask me (although usually not more than once) what exactly it is that I do. Sure, you’re a Business Intelligence slash data warehouse slash ETL specialist, but honestly; do you honestly expect us to know what that means? Management information? Huh? I usually answer the question by explaining that, on a […]
Fire and Forget: ETL and metadata
I’m a strong proponent of ‘fire and forget’. Once it’s built, ETL should just go to work and continue to work without failing. You shouldn’t need a whole army of administrators to keep your data warehouse filled with juicy up-to-date facts. Data logistics should be managed by exception, not by process.
This might seem like a […]
Scripting (because you’re always smarter than your tool)
When you are working with tools, you will always encounter some tasks that can not be performed by the tool itself. Informatica can not move files, let alone perform the more complicated actions. This is where the wonderful world of (Unix) scripting comes along. Since I was introduced in this world during my study I’ve […]
Ab Initio - The Dark Horse of ETL
If IBM and Informatica are the biggest powers in the land Extract, Transform ‘n Load, one of the closest runners-ups is - you’re bound to have heard of them - Ab Initio.
Excuse me? Who? What?
Well, I won’t blame you if you haven’t. Ab Initio is the industry’s dark horse, its mystery guest, the No Such […]






