Modifying Output Batch Properties And Post Processing Properties For Sample Analysis

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

brand
Software
prodname
Teradata Warehouse Miner
vrm_release
5.4.4
category
User Guide
featnum
B035-2300-077K

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