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 […]

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Fark
  • Technorati
  • del.icio.us
  • Google
  • StumbleUpon
Email This Post Email This Post


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 […]

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Fark
  • Technorati
  • del.icio.us
  • Google
  • StumbleUpon
Email This Post Email This Post


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 […]

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Fark
  • Technorati
  • del.icio.us
  • Google
  • StumbleUpon
Email This Post Email This Post


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 […]

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Fark
  • Technorati
  • del.icio.us
  • Google
  • StumbleUpon
Email This Post Email This Post


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 […]

These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Fark
  • Technorati
  • del.icio.us
  • Google
  • StumbleUpon
Email This Post Email This Post
Keep looking »