Uses Imported Data - System Emulation Tool

Teradata® System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-19
dita:mapPath
log1544831946868.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

Capturing data from a target (production) system and applying it to a test system is a two-phase process:

  1. Relevant data on the target system is read and then written to a staging area.
  2. The staged data is imported to the test system and applied to the appropriate data tables.

Imported data is used to do the following:

  • Recreate the Optimizer performance characteristics of the target system.
    The Optimizer generates query execution plans based on many factors, such as available system resources, indexes, primary and secondary keys, and available statistics. All of these factors impact how the Optimizer creates the most effective execution plan.
  • Generate query plans that emulate those created on the target system under a given set of conditions.
    A small test system can be used to generate query plans that emulate a much larger target system.

    If the imported data contains NOS objects, then the test system must have Advanced SQL Engine 17.00 or above installed.

  • Perform what-if modeling.
  • Test, diagnose, and solve optimizer-related performance questions that might occur in the target system.

Teradata SET also works with Teradata Visual Explain to emulate how a target system performs under specific conditions and workloads.