Snapshot of Test Data Mart

You can take a snapshot of the test data mart and manage the necessary information. You can create a history table in the database which holds the history of test matching.
tdm49
You can take a snapshot of the test data mart and manage the necessary information. You can create a history table in the database which holds the history of test matching.
Construct Test Data Mart History Table
Test mart History table is a table used to store the history of test matching. After successfully running the test match, test data mart table gets updated with necessary information. History table is needed to store the updated test mart after the test match. Construct a test mart history table in the database where the test mart is created. Ensure that your test mart history table contains all the columns of test data mart along with the columns to store the following information:
  • History Type
    • Data Type:
       VARCHAR or nvarchar for MS SQL Server; VARCHAR2 for Oracle.
    • Data Length (
      Recommended
      ): Minimum - 17; Maximum - as allowed in the database.
    • Example:
       MS SQL Server - VARCHAR(17); Oracle – VARCHAR2(17)
  • History Job ID
    • Data Type:
       Numeric for MS SQL Server; Number for Oracle.
    • Data Length:
       10
    • Example:
       MS SQL Server - NUMERIC(10); Oracle – NUMBER(10,0)
  • History Date
    • Data Type:
       DATE for both MS SQL Server and Oracle.
    • Example:
       DATE
  • History Notes
    • Data Type:
       VARCHAR or NVARCHAR for MS SQL Server; VARCHAR2 for Oracle.
    • Data Length (
      Recommended
      ): As allowed in the database.
    • Example:
       MS SQL Server - VARCHAR(200); Oracle – VARCHAR2(200)
Note:
Test Data Mart column names should not match with SQL Keyword. Do not use spaces in the column names.
Register Test Data Mart History
Registering test data mart history follows the same steps that you followed to register test data mart table. For more information refer Registering Test Data Mart.
Once test mart history table is registered, we need to map it’s columns in Test match Data Pool.
Follow these steps:
  1. Expand the project in which you created the Data Pool with type as Test Match.
  2. Right click the Data Pool, click Data Pool Properties.
  3. Go to the Test Matching tab and do the following:
    • Specify the following under the Tables and Columns tab:
      • Store History in table
      • History Date in column
      • History Notes in column
      • History Type in column
      • History Job in ID column
  4. Click the Save Details icon.
Take Snapshot
After creating the history table and adding the necessary new columns, you can take a snapshot of the test data mart. The snapshot pushes the locked and blocked rows to test mart history table. It supports three modes of snapshot:
  1. Pre-Match Snapshot
    Takes snapshot before performing the test match.
  2. Post-Match Snapshot
    Takes snapshot after performing the test match.
  3. No-Match Snaphot
    Takes snapshot without performing the test matching (current state).
Follow these steps:
  1. Right click the test match data pool in which you added the test case data criteria, and then click Test Match.
  2. Test Match window opens consisting of the Table and Columns, Key Columns and Runtime Parameters tabs.
  3. Go to the Runtime Parameters tab and select Show Advanced Options.
  4. Select one of the following from Advanced Options and click Match:
    • Snapshot Test Mart before matching
      Specifies the option to take snapshot before performing test match.
    • Snapshot Test Mart after matching
      Specifies the option to take snapshot after performing test match.
    • Snapshot Test Mart
      Specifies the option to take snapshot without performing test match.
Snapshot of locked and blocked rows for the test cases is created in Test Mart History table with History Job ID.