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

Merge Archived History Data While Segmenting Production Job

Merge Archived History Data While Segmenting Production Job

The merge archived history data while segmenting production job merges previously archived data with a configured segmentation group before it creates segments.
For example, a previously archived table may contain accounts receivable transactions from 2008 and 2009. You want to merge this data with a segmentation group you have created that contains accounts receivable transactions from 2010, 2011, and 2012, so that you can create segments for each of the five years. Run this job to combine the archived data with the accounts receivable segmentation group and create segments for each year of transactions.
The merge archived history data job applies the business rules that you configured to the production data. Run smart partitioning on the history data separately before you run the job.
If you choose not to merge all of the archived history data into its corresponding segments in the production database, the Audit Compare Snapshots job returns a discrepancy that reflects the missing rows in the row count report.
Provide the following information to run this job:
SourceRep
Source connection for the segmentation group. Choose from available source connections.
SegmentationGroupName
Name of the segmentation group that you want to merge with archived data. Choose from available segmentation groups.
LoggingOption
Option to log your changes. If you select logging, you can revert your changes.
Default is no.
AddPartColumnToNonUniqueIndex
Option to add the partition column to a non-unique index.
Default is no.
IndexCreationOption
Type of index the smart partitioning process creates for the merged and segmented tables.
Default is global.
BitmapIndexOption
Type of bitmap index the smart partitioning process creates for the merged and segmented tables.
Default is local bitmap.
GlobalIndexTablespaceName
Name of the tablespace you want to the global index to exist in. This field is optional.
CompileInvalidObjects
Option to compile invalid objects after the job recreates indexes.
Default is no.
ReSegmentFlag
Default is no.
CheckAccessPolicyFlag
Checks for an access policy on the segmentation group.
Default is yes.
ParallelDegree
Degree of parallelism used when the smart partitioning process creates segments.
Default is 4.
DropTempTablesBeforeIndexRebuild
Drops the temporary tables before rebuilding the index after segmentation.
Default is no.
DropTempSelTables
Drops the temporary selection tables after segmentation.
Default is yes.
ArchiveRunIdView
Database view that maps the partition ID to the archive ID.
ArchiveRunIdColumn
Name of the archive column.

0 COMMENTS

We’d like to hear from you!