检查数据完整性oracle etl [英] check for data completeness oracle etl
问题描述
我是oracle的新手,我想知道如何在ETL测试过程中检查完整的数据加载并验证边界值. (两个表可以是T1和T2).请让我知道一个示例查询.
I am new to oracle and I would like to know how do we check for complete data load and validate boundary values as part of the ETL testing process. (The two tables could be T1 and T2). Please let me know a sample query.
谢谢,桑托什
推荐答案
要验证数据完整性,请执行以下验证-:
To verify data completeness, perform following validations-:
•确保所有预期数据都已加载到目标表中.
•比较源和目标之间的记录计数.
•检查是否有任何拒绝的记录
•检查数据不应在目标表的列中被截断
• Ensure that all expected data is loaded into target table.
• Compare record counts between source and target.
• Check for any rejected records
• Check data should not be truncated in the column of target tables
您可以编写简单的减号查询以检查是否相同:
You can write simple minus queries to check the same-:
((Select [column1], [column2]…,[column n] from t1
Minus
Select [column1], [column2]…,[column n] from t2)
Union
(Select [column1], [column2]…,[column n] from t2
Minus
Select [column1], [column2]…,[column n] from t1
((Select [column1], [column2]…,[column n] from t1
Minus
Select [column1], [column2]…,[column n] from t2)
Union
(Select [column1], [column2]…,[column n] from t2
Minus
Select [column1], [column2]…,[column n] from t1
要检查边界值-:
Select * FROM t1 WHERE id NOT BETWEEN x AND y;
这篇关于检查数据完整性oracle etl的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!