Building a Successful ETL Project

by Allan Mitchell 28 Oct 2008 09:00
When we are building ETL projects we need to do some planning up front to make sure we have all the things we need to make it a success. Here are some of the things we consider when embarking on an ETL Project. There are two lists. The first is around an ETL Project in general and the second is around things we think about specifically for SSIS. Review target data model Identify source systems (Owners, RDBMS types, Permissions) Analyze and profile source systems (usge patterns, Windows of opportunity) Document source data defects and anomalies (known issues, data profiling) ... [More]


Comment RSS