Modifying Output Batch Properties And Post Processing Properties For Sample Analysis - 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

Listed below are the output properties to modify an existing Sample analysis.

The output properties and their possible values follow:
  • OutputStyle — “Select” “CreateTable”, “CreateMultipleTables, CreateMultipleViews”
  • OutputDatabase — name of existing database (valid for “CreateTable”, “CreateMultipleTables”, “CreateMultipleViews”)
  • OutputName — name of output table to be created (valid for “CreateTable”, “CreateMultipleViews”)
  • Fallback (valid for “CreateTable”, “CreateMultipleTables”) — “true” or “false”
  • Multiset (valid only if “CreateTable”, “CreateMultipleTables”) — “true” or “false”
  • GenerateSqlOnly — “true” or “false”
  • AdvertiseOutput (valid for all Create options) — “true” or “false”
  • AdvertiseNote (valid for all Create options) — optional comment or note for advertised output (only used if AdvertiseOutput attribute is “true” or if the Connection element AlwaysAdvertise attribute is “true”)

    An XML example to modify the SampleOutputProperties to “CreateTable” follows.

    <OutputProperties
    	outputStyle="CreateTable"
    	outputDatabase="twm_results"
    	outputName="MySampleOutput"
    	outputComment="My Sample comment"
    	collectStats="true"/>

    For “CreateMultipleTables”, each group of tables is defined by the following XML structure.

    <OutputProperties
    	outputStyle="CreateMultipleTables"
    	outputDatabase="twm_results"
    	outputComment="My Sample comment 2"
    	collectStats="true"/>
    <OutputTables>
    	<OutputTable Name="MySampleTable1"/>
    	<OutputTable Name="MySampleTable2"/>
    	<OutputTable Name="MySampleTable3"/>
    </OutputTables>

    For “CreateMultipleViews”, each group of views is defined by the following XML structure.

    <OutputProperties
    	outputStyle="CreateMultipleViews"
    	outputDatabase="twm_results"
    	outputName="MySampleOutputTable"
    	trailingSql="create index(&quot;income&quot;) on &lt;T&gt;;"/>
    <OutputViews>
    	<OutputView name="MySampleView1"/>
    	<OutputView name="MySampleView2"/>
    	<OutputView name="MySampleView3"/>
    </OutputViews>
The post processing properties, valid only for outputStyle “Create Table”, “CreateMultipleTables” or “CreateMultipleViews”, have the following possible values:
  • OutputComment — the output comment string to be used
  • CollectStats (valid for “CreateTable”, “CreateMultipleTables”) — “true” or “false”
  • CollectSample (valid for “CreateTable”, “CreateMultipleTables”) — “true” or “false”
  • TrailingSql — the post processing SQL commands to execute