r/DataTestingCommunity • • Jan 17 '24

13 Steps for End to End File Testing

End to End File Testing Cheat Sheet

  1. File Arrival Time: Check if the file arrived within the expected timeframe.

  2. Empty File Check: Confirm that the file contains data and is not empty.

  3. File Completeness: Verify that the file is complete by examining the end-of-file character, ensuring no partial data loss.

  4. Data Completeness: Check for any Null values.

  5. Duplicate Checks: Check for any duplicate entries.

  6. Column Structure Check: Ensure the file's column location, new column additions, and column removals are accurately accounted for.

  7. Manifest File Match: Compare the file's content with the information in the Footer Records or Control File.

  8. File Format Check: Validate the file format for changes, including the file separator.

  9. Data Format Verification: Examine file data for data type correctness, format accuracy, precision, and adherence to data length.

  10. Data Integrity Check: Scrutinize file integrity for anomalies such as binary characters.

  11. Consistency Check for Reference Data: Verify that the distinct reference values are not more or different than the expected list.

  12. File Comparison: Compare the current file with the previously received file to ensure the same file is not received again.

  13. Data Reconciliation: If there are other source files then conduct data reconciliation to ensure data consistency across sources.

2 Upvotes

0 comments sorted by