About this Article:
This article will discuss an approach to designing an ETL system in VFP as part of the overall data-warehousing project. I will provide two additional source data files as well and rely once again on the Northwind database. These source systems will be “ETLed” into the Dimensional Model I designed in the first article. I plan to provide a complete solution with source code, diagrams, and screenshots.
Tod McKenna is a business intelligence and data warehousing consultant for Contraste Europe. He has worked on various data warehousing and data integration projects for Certified Revaluation Company, Cardinal Health, ING, and others. A longtime Visual FoxPro developer, Tod spends his days working with SQL Server and its BI stack. By night, Tod writes his technology blog at blog.todmeansfox.com. www.linkedin.com/in/todmckenna tod@blackstoneprovidence.com