Informatica != SSIS (part 1)

Hopping from assignment to assignment (or continent to continent for some of you) you’re bound to work with various pieces of software. From Cognos to Business Objects, from Oracle to MS SQL server, or from Informatica to Microsofts SSIS. It is ’stating the obvious’ to say that all those programs -despite having similar goals and […]

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


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


The Treasure Trove Called Informatica Repository

If you’re an Informatica PowerCenter specialist, you’ll agree with me that there is a lot of fun stuff you can do if you’re willing to take a step beyond its comfortable graphical interface. Let’s face it: a tool that has made itself so completely metadata-driven is just asking for some serious tweakage.
Take the PowerCenter Repository, […]

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