Category Attribute Snapshot Table

The category attribute snapshot table view is sometimes called the “vertical snapshot table”, because instead of the attributes making up the columns of the table, they make up the rows. They are arranged in this manner to allow the category attribute snapshot table view to overcome the database limitation of allowing only 1022 columns, thereby freeing EnterWorks repositories to have an unlimited number of category attributes in the snapshot tables.

To trigger the creation of a repository’s category attribute snapshot table, using the EnterWorks Classic UI, edit the repository’s properties and check the repository’s Create Category Attribute Snapshot box. The category attribute snapshot table will be created the next time the snapshot tables are rebuilt. (For instructions on editing a repository’s properties and rebuilding snapshot tables, see the EnterWorks 10 Administration Guide).

Open the CZ Vehicle Staging Repository's Properties for Editing

Set the Repository's Create Category Attribute Snapshot Flag

A category attribute snapshot table view has the same name as the main snapshot table, except that it has a suffix of “_KV”. KV stands for “key value pairs”. So if a repository is named:

Product_Staging

its category attribute snapshot table view would be named:

Product_Staging_KV

A repository’s category attribute snapshot table has a row for each record’s non-null category attributes, whether the category attribute has been marked as relational or not. The schema of each row is:

  • InternalRecordId: This maps to the InternalRecordId of the record in the repository. It can be used to join a category attribute snapshot table row to a row in the main snapshot table.
  • KeyName: The name of the category attribute. This will exactly match the attribute name in the repository, which can be seen by viewing the repository’s profile or opening the repository in EnterWorks’s Detail Editor.
  • KeyRestrictedName: The restricted name of the attribute, as defined in the repository’s attribute definition.
  • KeyValue: The attribute’s value.
  • KeySequence: If a display sequence is set for the attributes in the repository, an attribute’s sequence value will be reflected in the category attribute snapshot table’s attribute’s KeySequence field.

The Item_Staging Repository’s Category Attribute Snapshot Table Columns

If a category attribute is designated as relational and the repository has a category attribute snapshot table, the category attribute will appear in both the main snapshot table and in the category attribute snapshot table.