Examples | Data Explorer | Vantage Analytics Library - Examples - Vantage Analytics Library

Vantage Analytics Library User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Vantage Analytics Library
Release Number
2.2.0
Published
March 2023
Language
English (United States)
Last Update
2024-01-02
dita:mapPath
ibw1595473364329.ditamap
dita:ditavalPath
iup1603985291876.ditaval
dita:id
zyl1473786378775
Product Category
Teradata Vantage

These examples demonstrate the performance of the valid combinations of analyses with a single input table.

All Analyses, Output Tables with Default Names

Performs all analyses (Values, Statistics, Frequency, and Histogram) and creates output tables for each of these analyses with default names.

call td_analyze (
  'dataexplorer',
  'database = val_source;
   tablename = customer;
   outputdatabase = val_results;'
');

Values Analysis, Named Values Output Table

call td_analyze (
  'dataexplorer',
  'database = val_source;
   tablename = customer;
   outputdatabase = val_results;
   valuesoutputtablename = v1;'
);

Statistics Analysis, Named Statistics Output Table

call td_analyze (
  'dataexplorer',
  'database = val_source;
   tablename = customer;
   outputdatabase = val_results;
   statisticsoutputtablename = s1;'
);

Values and Statistics Analyses, Named Output Tables

call td_analyze (
  'dataexplorer',
  'database = val_source;
   tablename = customer;
   outputdatabase = val_results;
   valuesoutputtablename = v1;
   statisticsoutputtablename = s1;'
);

Values and Frequency Analyses, Named Output Tables

call td_analyze (
  'dataexplorer',
  'database = val_source;
   tablename = customer;
   outputdatabase = val_results;
   valuesoutputtablename = v1;
   frequencyoutputtablename = f1;'
);

Values, Statistics, and Histogram Analyses, Named Output Tables

call td_analyze (
  'dataexplorer',
  'database = val_source;
   tablename = customer;
   outputdatabase = val_results;
   valuesoutputtablename = v1;
   statisticsoutputtablename = s1;
   histogramoutputtablename = h1;'
);

All Analyses, Named Output Tables

call td_analyze (
  'dataexplorer',
  'database = val_source;
   tablename = customer;
   outputdatabase = val_results;
   valuesoutputtablename = v1;
   statisticsoutputtablename = s1;
   frequencyoutputtablename = f1;
   histogramoutputtablename = h1;'
);