Construct Test Data Mart

The Test Data Mart is a collection of summary tables built up from the core attributes identified in your test criteria. Construct a Test Mart within a database and register with Datamaker using a connection profile. Ensure that your test mart includes necessary columns to store the following information:
tdm10
The Test Data Mart is a collection of summary tables built up from the core attributes identified in your test criteria. Construct a Test Mart within a database and register with Datamaker using a connection profile. Ensure that your test mart includes necessary columns to store the following information:
  •  
    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)
  •  
    Expected Results
    •  
      Data Type:
       VARCHAR or NVARCHAR for MS SQL Server; VARCHAR2 or CLOB for Oracle.
    • Data Length (
      Recommended
      ): Minimum - 200; Maximum - as allowed in the database.
       
    •  
      Example:
       MS SQL Server - VARCHAR(max); Oracle - CLOB(max)
  •  
    Test Name
    If multiple test cases acquire a read-share lock, the value in this column is proportional to the number of test cases allocated for the shared record.
    •  
      Data Type:
       VARCHAR or NVARCHAR for MS SQL Server; VARCHAR2  or CLOB for Oracle.
    • Data Length (
      Recommended
      ): Minimum - 306; Maximum - as allowed in the database.
       
    •  
      Example:
       MS SQL Server - VARCHAR(max); Oracle - CLOB(max)
  •  
    Test Locking
    If multiple test cases acquire a read-share lock, the value in this column is proportional to the number of test cases allocated for the shared record.
    •  
      Data Type:
       VARCHAR or NVARCHAR for MS SQL Server; VARCHAR2  or CLOB for Oracle.
    • Data Length (
      Recommended
      ): Maximum
       
    •  
      Example:
       MS SQL Server - VARCHAR(max); Oracle - CLOB(max)
  •  
    Test User
    If the testers are allowed to do a read-share lock, the value in the "Test User" column is proportional to the number of users allocated for the shared record.
    •  
      Data Type:
       VARCHAR or NVARCHAR for MS SQL Server; VARCHAR2  or CLOB for Oracle.
    • Data Length (
      Recommended
      ): Minimum - 200; Maximum - as allowed in the database.
       
    •  
      Example:
       MS SQL Server - VARCHAR(max); Oracle - CLOB(max)
Review the following points when defining Test Data Mart columns:
  • Test Data Mart column names should not match with the SQL keywords.
  •  Do not use spaces in the column names.
  • Ensure that the Test Data Mart columns are defined with appropriate data types including the required maximum length. For example, a test match might result in the number of entries that exceed the limit applied on the Test Data Mart column data type. In this case, the test match fails and an error is displayed. To address such situations, we recommend that you define your column data types based on your business requirements. For example,
    nvarchar(max)
    .