Resource / ETL Testing Concepts ETL Testing Concepts Sandesh Gawande 18 April 2022 10 min read What is ETL Testing? ETL testing verifies that an ETL process accurately extracts, transforms, and loads data according to the specifications. ETL testing is done by validating and/or comparing the input and output data transformed by the…
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.
