Conchango, a leading provider of technology-driven business solutions in the United Kingdom, explores how the new SQL Server 2005 Integration Services compares with Informatica. The paper provides specific comparisons of the concepts and constructs involved in developing extract, transform, and load (ETL) solutions using the two products in focus. It provides guidance on how to apply Informatica PowerCenter concepts in the SQL Server 2005 Integration Services design environment.
| • | Introduction |
| • | Product Architecture |
| • | Functional Comparison |
| • | Conclusion |
| • | Terminology |