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. Data Privacy
  18. Oracle E-Business Suite Retirement Reports
  19. JD Edwards Enterprise Retirement Reports
  20. Oracle PeopleSoft Applications Retirement Reports
  21. Language Settings
  22. Appendix A: Data Vault Datatype Conversion
  23. Appendix B: Special Characters in Data Vault
  24. Appendix C: SAP Application Retirement Supported HR Clusters
  25. Appendix D: Glossary

Create Indexes on Data Vault

Create Indexes on Data Vault

Before you can search for records across applications in Data Vault, you must first create search indexes. Run the Create Indexes on Data Vault job to create a search index for each table that you want to include in the search.
If you add or remove columns from the search index, delete the search indexes first. Then run the Create Indexes on Data Vault to create the new indexes. Alternatively, you can run the Reindex on Data Vault standalone job, which runs the Delete Indexes on Data Vault job and the Create Indexes on Data Vault job back-to-back.
If the job fails while creating the indexes, some table records are indexed multiple times when you resume the job. To remove the duplicate indexing, run the Delete Indexes on Data Vault job and select the connection and table from the list of values. After the Delete Indexes on Data Vault job is complete, run the Create Indexes on Data Vault job again with the same connection and table selected for the job.
Provide the following information to run this job:
Destination Repository
Required. Database with archived data.
Entity
Optional. The name of the entity for the table with the columns you want to add or remove from the search index.
Table
Optional. The name of the table with the columns you want to add or remove from the search index. Verify that you have selected the columns for indexing in the Enterprise Data Manager. If a table does not have any columns selected for indexing, the job enters a warning state.

0 COMMENTS

We’d like to hear from you!