1.Data completeness test are designed to verify that all the
expected data loads into the DWH.
2.It includes running detailed tests to verify
that all records,all fields and full contents of each field are loaded correctly or not.
3.Strategies to consider includes:
a)Record counts must compared between source and the target
data.
b)Comparing record counts between source and data loaded to
the warehouse (Target) and also rejected records in
c)Comparing unique values of key fields between source data
and data loaded to the warehouse (Target) column mapping from the source or stage.
4.Populating the full contents of each field to validate that
have no truncation occurs at any step in the process for example if the source
data fields is having string(30) and make sure that to test it with 30 characters.
No comments:
Post a Comment