However, there are several reasons that using an ETL tool is an industry standard best practice:
- Self-documentation that comes from using a graphical tool. A hand-coded system is usually an impenetrable mess of staging tables, SQL scripts, stored procedures, and operating system scripts.
- Metadata foundation for all steps of the ETL process.
- Version control for multi-developer environments and for backing out and restoring consistent versions.
- Advanced transformation logic, such as fuzzy matching algorithms, integrated access to name and address deduplication routines, and data mining algorithms.
- Improved system performance at a lower level of expertise. Rela...
- Chapter 20: ETL System Design and Development Process and Tasks
- from The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling, 3rd Edition
- Publisher: John Wiley & Sons
- Released: July 2013
These are right in line with the reasons I gave for the question "Why an ETL Tool?"
Share this highlighthttp://learning.oreilly.com/a/the-data-warehouse/17765/