Warning: Depending on the number of records being processed, rebuilding,
dropping, or populating a snapshot table can take a significant amount of time,
during which system performance may be impacted and data in the table may not be
an accurate copy of the repository's attribute values. To prevent system
slow-down and the accidental use of unreliable data, manage snapshot tables
during non-business hours.
Warning: When a snapshot table is rebuilt, the view is deleted and a new
one is generated. Any users who had access that was explicitly granted to the
old view will no longer have access to it, nor will they have access to the new
view until that explicit access has been re-granted. This can be avoided by
granting general access to the views so if a view is re-created, it can be
accessed without being explicitly granted.
You can perform the following actions on a repository's snapshot table:
- Full snapshot population: This is also called "rebuilding" a snapshot table. Rebuilding a repository's snapshot table repopulates the entire table. EnterWorks will clear any existing records from the snapshot table, then for each record in the repository, write the values of the attributes included in the snapshot table to the snapshot table. It is recommended that when you repopulate the snapshot table, you drop it also.
- Full snapshot population and drop the snapshot table: This is also called "dropping" the snapshot table. If you drop the snapshot table, the table will be entirely recreated, then EnterWorks will retrieve the values of all the attributes in the snapshot table for all the records in the repository, and store them in the new snapshot table. Dropping and recreating the snapshot table guarantees that the snapshot table matches the repository's profile and it takes just as much time as only repopulating the table.
- Populate missing records: If there are any records in the repository that have not been added to the snapshot table, EnterWorks will add those records to the snapshot table. This is particularly useful if a snapshot job has been interrupted or stopped and not all records were added to the snapshot table.