Testing of software systems is always challenging, but testing data integration systems is especially difficult. Complex logic for consolidating data from disparate sources, data quality problems in source systems, "surprise" changes in source systems, and other factors combine to make data integration testing uniquely challenging. Although concepts of unit testing, stream testing, and system testing are still important, they alone are not adequate to the task of ensuring quality in data warehousing and data integration systems.
This course uses a combination of lecture, examples, and practice to teach effective testing techniques for data integration. From data profiling to stress and regression tests, you'll learn about effective models that can be used to apply the most powerful testing techniques throughout the data integration lifecycle.