Changing the Demographics Export Options - 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

Select the Demographics check box to export information about tables (demographic data). Demographics can only be captured and imported when a QCD is specified during an export operation. Captured demographics are collected in the specified QCD. To export demographics information in addition to the information exported when All is selected, select the Demographics check box.

Depending on the type of export operation performed, this feature either captures demographics of the tables and indexes referenced in a query or samples of all of the tables in a given database.

  1. From an export dialog box, click Options.
  2. Click Select Tables.
  3. Define the way that demographics are exported.
    Option Description
    Capture from QCD database Export demographic rows, if available, from the active QCD source for the elements (objects) specified in the Demographics Source box. If rows do not exist for the selected elements, current demographics are collected into the QCD source, exported, then deleted from the QCD source.
    Capture Current Demographics Export current demographics into the QCD source that is specified in the Demographics Source box. If demographics for a table exist, the row is updated. If demographics for a table do not exist, the demographics inserted into the QCD are deleted after the row is exported.
  4. [Optional] To view a graph or chart of the demographics for a selected table:
    1. Select a row under Select Rows.
    2. Click View Demographics.

      The Demographics interface opens. Use the interface to display demographic data in various formats. For more information about the Demographics interface, see Teradata® Index Wizard User Guide, B035-2506.

  5. Click OK two times to close the Export Demographics and Export Options dialog boxes.