Modifying Output Batch Properties And Post Processing Properties - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.4
Published
July 2017
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
wbc1492033894304.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software

For all analysis categories of type ADS, Descriptive Stats, Reorganization, Scoring and Statistical Tests, batch output properties and post processing properties can be modified using the batch XML interface. All the analyses will use the following batch properties, except for Data Explorer, Sample, Scoring and PMML Scoring, which have their own definition of these properties and are defined below.

To modify an existing analysis with categories of type ADS, Descriptive Stats, Reorganization, and Statistical Tests, the output and post processing properties are defined below. Note that post processing properties are only defined when the output style is create table or view, unless otherwise stated. Also, OutputStyle should be set first before other output properties if it is being changed or if the analysis is new. Most output properties only apply when the OutputStyle option is CreateTable or CreateView, with exceptions noted below.

The convention of representing the output table as '<T>' requires some awkward syntax in XML, as in the following example where the trailing SQL
create index("income") on <T>;

is represented as

trailingSql="create index(&quot;income&quot;) on &lt;T&gt;;"/>

An XML example of modifying the Output Properties of an existing ADS analysis follows.

<OutputProperties
	outputStyle="CreateTable"
	outputDatabase="twm_results"
	outputName="MyBuildADS"
	fallback="true"
	outputComment="My ADS comment"
	collectStats="true"/>

Teradata Database

The output properties and their possible values when connected to a Teradata database follow:
  • OutputStyle — “CreateTable”, “CreateView”, “Select” or “Explain”
  • OutputDatabase — name of existing database
  • OutputName — name of output table to be created
  • GenerateSqlOnly (valid with all values of OutputStyle) — “true” or “false”
  • AdvertiseOutput — “true” or “false”
  • AdvertiseNote — optional comment or note for advertised output (only used if AdvertiseOutput is “true” or if the Connection property AlwaysAdvertise is “true”)

    The post processing properties, valid only for outputStyle “Create Table” or “CreateView”, and their possible values are:

  • TrailingSql — the post processing SQL command(s) to execute.

Aster Database

The output properties and their possible values for Descriptive Statistics functions when connected to an Aster database follow:
  • OutputStyle — “CreateTable”, “CreateView”, “Select” or “Explain”
  • OutputSchema — name of existing schema
  • OutputName — name of output table to be created
  • GenerateSqlOnly (valid with all values of OutputStyle) — “true” or “false”
  • AdvertiseOutput — “true” or “false”
  • AdvertiseNote — optional comment or note for advertised output (only used if AdvertiseOutput is “true” or if the Connection property AlwaysAdvertise is “true”)

    The post processing properties, valid only for outputStyle “Create Table” or “CreateView”, and their possible values are:

  • TrailingSql — the post processing SQL command(s) to execute.
The output properties and their possible values for ADS and Reorganization functions (including Sample) when connected to an Aster database are:
  • OutputStyle — “CreateTable”, “CreateView”, “Select” or “Explain”
  • OutputSchema — name of existing schema
  • OutputName — name of output table to be created
  • GenerateSqlOnly (valid with all values of OutputStyle) — “true” or “false”
  • AdvertiseOutput — “true” or “false”
  • AdvertiseNote — optional comment or note for advertised output (only used if AdvertiseOutput is “true” or if the Connection property AlwaysAdvertise is “true”)
  • TableUsage — “FACT” or “DIMENSION”
  • TableDistribution — “BYHASH” or “BYREPLICATION”
  • TablePersistence — “PERMANENT” or “ANALYTIC”
  • TableStorage — “ROW” or “COLUMN”
  • TableCompression — “LOW”, “MEDIUM”, “HIGH” or “NONE”
  • HashDistributionColumn — name of column to hash distribute by
The post processing properties, valid only for outputStyle “Create Table” or “CreateView”, and their possible values follow:
  • TrailingSql — the post processing SQL command(s) to execute.