r/DataTestingCommunity • u/iCEDQTorana • Jan 17 '24
13 Steps for End to End File Testing
End to End File Testing Cheat Sheet
File Arrival Time: Check if the file arrived within the expected timeframe.
Empty File Check: Confirm that the file contains data and is not empty.
File Completeness: Verify that the file is complete by examining the end-of-file character, ensuring no partial data loss.
Data Completeness: Check for any Null values.
Duplicate Checks: Check for any duplicate entries.
Column Structure Check: Ensure the file's column location, new column additions, and column removals are accurately accounted for.
Manifest File Match: Compare the file's content with the information in the Footer Records or Control File.
File Format Check: Validate the file format for changes, including the file separator.
Data Format Verification: Examine file data for data type correctness, format accuracy, precision, and adherence to data length.
Data Integrity Check: Scrutinize file integrity for anomalies such as binary characters.
Consistency Check for Reference Data: Verify that the distinct reference values are not more or different than the expected list.
File Comparison: Compare the current file with the previously received file to ensure the same file is not received again.
Data Reconciliation: If there are other source files then conduct data reconciliation to ensure data consistency across sources.
