VTCP Testing Compliance Matrix
Use the matrix below to identify the specific DV2 standards or recommended best practices the current list of certified tools have met. Be sure to check the Vendor’s Certificate for the tool name and version to which the certification testing passed. Only the tool names and versions displayed on the Certificate of Compliance were submitted for evaluation. DVA does not issue blanket certifications to vendors.
| Feature Tested | 2003 | 2024 |
|---|---|---|
| Global Naming Convention Consistency | y | y |
| Ghost Record physical pattern | y | y |
| Null Key Concept records (Required and Optional) physical pattern | y | y |
| Physical object structural Patterns | y | y |
| Physical object classes | y | y |
| Physical object class constraint patterns and abbreviation consistency | y | y |
| Physical object schema names | y | y |
| Physical schema maps to logical schema names | y | y |
| Physical table class patterns and abbreviation consistency | y | y |
| Physical table class mappings and table naming conventions | y | y |
| Physical column class logical naming conventions | y | y |
| Physical column class mappings to table class mappings | y | y |
| Logical object classes must map to physical object classes | y | y |
| DDL Foreign Key assignments | y | y |
| In source to target processes check for the LDTS or RSRC in the Raw vault | y | y |
| Physical Primary Key (Hash Key) Uniqueness | y | y |
| Valid Hash Key value computation | y | y |
| Valid Hash Difference value computation | y | y |
| Process execution validation (through data balancing) | y | y |
| Physical end-date Satellites with SQL Update | y | y |
| Stage Level 1 structural integrity | y | y |
| Stage Level 2 structural integrity | y | y |
| Raw Vault Hub Loads - no duplicates | y | y |
| Raw Vault Link Loads - no duplicates | y | y |
| Raw Vault Satellite Loads - delta checking | y | y |
| Raw Vault Effectivity Satellite Loads | y | y |
| Raw Vault Effectivity Satellite Delta Data Detection | y | y |
| Raw Vault Hierarchical Link Loads - no duplicates | y | y |
| Raw Vault Same As Link Loads - no duplicates | y | y |
| Raw Vault Link Hash Key Computation | y | y |
| Business Vault PIT Structural integrity | y | y |
| Business Vault Bridge Structural Integrity | y | y |
| Business Vault PIT Loads | y | y |
| Business Vault Bridge Loads | y | y |
| Raw Vault Multi-Active Satellite Loads | y | y |
| Raw Vault Multi-Active Satellite Structural Integrity | y | y |
| Raw Vault Transactional / Non-Historized Link Loads | y | y |
| Structure handle Late Arriving Data | n | y |
| Process handles Late Arriving Data | n | y |
| Satellite sub-sequence keys | n | y |
| Out-of-order Satellite Data Sets | n | y |
| Multi-intra-day Satellite Data Sets | n | y |
