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.
create index("income") on <T>;
is represented as
trailingSql="create index("income") on <T>;"/>
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
- 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
- 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.
- 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
- TrailingSql — the post processing SQL command(s) to execute.