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






