ETL Testing Tutorial
ETL Testing Useful Resources
Selected Reading
- ETL Testing - Interview Questions
- ETL Testing - Best Practices
- ETL Testing - Automation
- ETL Testing - Backup Recovery
- ETL Testing - Data Completeness
- ETL Testing - Data Quality
- ETL Testing - Data Transformations
- ETL Testing - Metadata
- ETL Testing - Data Accuracy
- ETL Testing - Scalability
- ETL Testing - Performance
- ETL Testing - Scenarios(Test Cases)
- ETL Testing - Process
- ETL Testing - Techniques
- ETL Testing - Challenges
- ETL Testing - Categories
- ETL vs Database Testing
- ETL Testing - Tasks
- ETL Testing - Introduction
- ETL Testing - Home
ETL Testing Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
ETL Testing - Data Completeness
ETL Testing – Data Completeness
核对数据的完整性是为了核实目标系统中的数据在装载后是按预期计算的。
可为此进行的共同测试如下:
核对综合功能(总、最大、最高、计数)
核对和核实数据以及源与未变或简单转变的栏目的目标之间的实际数据。
Count Vapdation
比较来文方和指标表的记录数目。 可以通过撰写以下询问:
SELECT count (1) FROM employee; SELECT count (1) FROM emp_dim;
Data Profile Vapdation
它涉及核对源头和目标表(事实或层面)的合计功能,如计算、总和最大。
Column Data Profile Vapdation
它涉及对不同价值的不同价值和各行的权数进行比较。
SELECT city, count(*) FROM employee GROUP BY city; SELECT city_id, count(*) FROM emp_dim GROUP BY city_id;
Duppcate Data Vapdation
它涉及在一栏或各栏中确认主要关键和独特关键,这些栏目应根据业务要求具有独特性。 您可使用以下查询方法进行重复数据验证。
SELECT first_name, last_name, date_of_joining, count (1) FROM employee GROUP BY first_name, last_name HAVING count(1)>1;Advertisements