Creating a New or Modifying an Existing Values Analysis - Teradata Warehouse Miner

In order to create a new or modify an existing Values analysis, the following analysis properties are defined:

Analysis Properties

• Type — “Values” (needed only if “new” is “true”)
• Name — the name of the new Values analysis or the name of an existing Values to modify
• New — “true” (needed to define a new Values analysis)
• Modify — “true” (needed to modify an existing Values analysis)

InputDataProperties needs to be defined if this is a “new” analysis. InputDataProperties takes a database, table, and a list of numeric or date type columns. If the analysis is being modified, the InputDataProperties can be redefined. They will replace the existing set of columns that were originally defined for the analysis.

Column Input Data

• Database — the name of the database
• Table — the name of the table
• Columns — a list off column names
  • Name — the name of the column

An XML example to define columns for a new analysis follows.

<InputDataProperties>
	Database="twm_source"
	Table="twm_customer">
	<Columns>
		<Column name="age"/>
		<Column name="income"/>
		<Column name="gender"/>
	</Columns>
</InputDataProperties>

GroupBy Column Input Data (optional)

• GroupBy Columns
  • Name — the name of the group by column

An XML example to define Columns and GroupBy Columns follows.

<InputDataProperties>
	Database="twm_source"
	Table="twm_customer">
	<Columns>
		<Column name="age"/>
		<Column name="income"/>
		<Column name="gender"/>
	</Columns>
	<GroupByColumns>
		<GroupByColumn name="nbr_children"/>
	</GroupBYColumns>
</InputDataProperties>

Input Data Analysis Properties

• ComputeUniqueValues — “true” or “false”. Default is “true”.

An XML example to define InputDataAnalysis properties follows.

<InputDataAnalysisProperties
	computeUniqueValues=”true”/>

Output Properties

For the definition of output properties, see Modifying Output Batch Properties And Post Processing Properties.

Expert Properties

• WhereClause — the where clause to be defined

An XML example to define Expert properties follows.

<ExpertProperties>
	whereClause=”age>50”/>

Sample XML Definition for a New Values Analysis

<Analysis name="MyValues" type="Values" new="true">
	<InputDataProperties
		Database="twm_source"
		Table=”twm_customer”
		<Columns>
			<Column name=”age”/>
			<Column name=”income”/>
			<Column name="gender"/>
		</Columns>
		<GroupByColumns>
			<GroupByColumn name=”nbr_children”/>
		</GroupByColumns>
	</InputDataProperties>
	<InputDataAnalysisProperties
		computeUniques=”true”/>
	<OutputProperties
		outputStyle="CreateTable"
		outputDatabase="twm_results"
		outpuName="MyValuesOutput"
	</OutputProperties >
</Analysis>