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

Data Vault Loader Job

Data Vault Loader Job

When you publish an archive project to archive data to the Data Vault, Data Archive moves the data to the staging directory during the Copy to Destination step. You must run the Data Vault Loader standalone job to complete the move to the Data Vault. The Data Vault Loader job executes the following tasks:
  • Creates tables in the Data Vault.
  • Registers the Data Vault tables.
  • Copies data from the staging directory to the Data Vault files.
  • Registers the Data Vault files.
  • Collects row counts if you enabled the row count report for the Copy to Destination step in the archive project.
  • Deletes the staging files.
  • Generates a row count report and a row count summary report accessible under the Job ID on the
    Monitor Jobs
    page. The row count report lists each entity loaded to the Data Vault by archive job ID, along with the tables for each entity and row counts in the source database and the Data Vault archive folder. The report also lists any discrepancies. The row count summary report is a summary of the Data Vault Loader job, and lists each table loaded to the Data Vault along with their source row count, Data Vault archive folder row count, and any discrepancies.
Provide the following information to run this job:
  • Archive Job ID. Job ID generated after you publish an archive project. Locate the archive job ID from the
    Monitor Job
    page.
Data Vault supports a maximum of 4093 columns in a table. If the Data Vault Loader tries to load a table with more than 4093 columns, the job fails.

0 COMMENTS

We’d like to hear from you!