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 […]
Why SSIS isn’t there (yet)
Disclaimer: this text may be slightly biased and affected by a lack of experience with SSIS. If I missed all the easy options to solve the issues mentioned below, please let me know.
After working with Informatica PowerCenter for 3 years, I had the opportunity of working with SSIS (SQL Server 2005) for a short while. […]
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, […]






