Snapshot Table Views
In order for EnterWorks to accept record attribute values that may be invalid or exceed database limits, EnterWorks stores them in XML. Accessing or manipulating these attribute values requires parsing the XML, which can be time-consuming. For performance reasons, values that need to be accessed quickly or frequently can be included in the Empower DataMart Snapshot Table Views, (commonly called "snapshot tables"). EnterWorks copies the indicated XML values, parses them, and stores them in the snapshot tables, in appropriately data-typed columns, where they can be searched and accessed quickly and efficiently. Only valid attribute values will be copied to the snapshot tables; invalid values will be stored as NULL.