Data Completeness Test

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 warehouse (Target).

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.