ETL Testing April 18, 2022. ETL Testing Concepts This guide provides core concepts of ETL testing. This knowledge is gained while developing iceDQ software and learning from numerous implementations of ETL testing projects. Let’s dive right in. Table of Contents What is ETL Testing?ETL Testing BasicsHow to do ETL Testing?1. Difference between manual testing and…
iCEDQ is a Quality Assurance and Test Automation platform for data-centric projects and processes such as data warehouse, CRM, data migration & conversion, ETL. It certifies the ETL processes or migration by effective ETL Testing and Data Migration Testing. The product can be further used for monitoring the data processes in production. The product emphasizes mainly process quality.
The major difference between iCEDQ & other Data Quality tools is the purpose they serve. iCEDQ is a test automation platform for process quality whereas other Data Quality tools are a combination of data profiling & fixing/ correction tool used in production.
A source table has an individual and corporate customer. The requirement is that an ETL process should take the corporate customers only and populate the data in a target table. The test cases required to validate the ETL process by reconciling the source (input) and target (Output) data. The transformation rule also specifies that output should only have corporate customers.
Data has become critical to the business. Hence, enterprises are investing time, money and resources in data-centric systems such as data warehouse, MDM, CRM & migration projects. However, all research done by independent agencies indicates that, There is such a high failure/delays in implementations of data-centric projects, Users still don’t trust data coming from data warehouses.
