Table of Contents

Search

  1. Preface
  2. Introduction
  3. Accessing Data Archive
  4. Working with Data Archive
  5. Scheduling Jobs
  6. Viewing the Dashboard
  7. Creating Data Archive Projects
  8. Salesforce Archiving
  9. SAP Application Retirement
  10. Creating Retirement Archive Projects
  11. Integrated Validation for Archive and Retirement Projects
  12. Retention Management
  13. External Attachments
  14. Data Archive Restore
  15. Data Discovery Portal
  16. Data Visualization
  17. Oracle E-Business Suite Retirement Reports
  18. JD Edwards Enterprise Retirement Reports
  19. Oracle PeopleSoft Applications Retirement Reports
  20. Smart Partitioning
  21. Smart Partitioning Data Classifications
  22. Smart Partitioning Segmentation Policies
  23. Smart Partitioning Access Policies
  24. Language Settings
  25. Appendix A: Data Vault Datatype Conversion
  26. Appendix B: Special Characters in Data Vault
  27. Appendix C: SAP Application Retirement Supported HR Clusters
  28. Appendix D: Glossary

Row Checksum

Row Checksum

During the copy to destination step of the archive or retirement project, the validation process calculates a checksum value for each row in every table in the entity.
The process writes the row checksum values to a BCP file that appends the values to the end of each row. The process appends the checksum values as a metadata column that is copied to the Data Vault along with the table. When the Data Vault loader is finished, Data Vault calculates a second checksum value for each row in the archived or retired tables.
The validation process then compares the checksum value written to the BCP file to the checksum value calculated by Data Vault. When the checksum comparison is complete, review the validation for any deviations that occur between the two checksum values for each row.

0 COMMENTS

We’d like to hear from you!