Examples of Batch XML Files - Teradata Warehouse Miner - 5.4.4

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

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

Several examples of batch XML files are given here, showcasing types of analyses that may not be available in all Teradata Warehouse Miner products, specifically in Teradata Profiler and Teradata ADS Generator.

An example XML file to modify the output attributes and post processing attributes of an existing Decision Tree score analysis follows.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Startup>
	<ErrorLog fileName="C:\Temp\BatchErrors.log"/>
	<Silent filename="C:\Temp\BatchMessages.log"/>
	<Connection name="twm batch demo" type="System" userId="twm"/>
	<Project name="Help Tutorials - Algorithms and Scoring" save="true">
		<Analysis name="Decision Tree Scoring Tutorial" modify="true" execute="true">
			<OutputProperties
				outputDatabase="twm_results"
				outputName="My Logistic Score Output"
				collectStats="true"
				outputComment="My Comment"/>
		</Analysis>
	</Project>
</Startup>

An example XML file to create a new project and a new Data Explorer analysis follows. See the Data Explorer documentation in the help file or Data Explorer for the definition of each of the XML elements and attributes relating to the Data Explorer analysis.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Startup>
	<ErrorLog fileName="C:\Temp\errors.log"/>
	<Silent fileName="C:\Temp\messages.log"/>
	<Connection
		name="twm batch demo"
		type="System"
		userId="twm"/>
	<Project
		name="My New Project"
		execute="true"
		new="true"
		save="true">
		<Analysis
			name="My New DataExplorer"
			type="Data Explorer"
			new="true">
			<InputDataProperties>
				<Tables>
					<Table name="twm_customer"
						database="twm_source"/>
					<Table name="twm_checking_acct" database="twm_source"
						WhereClause="cust_id > 0"/>
				</Tables>
			</InputDataProperties>
			<InputDataAnalysisProperties
				computeUniques="true"
				statisticsOptions="minimumSet"
				statisticalMethod="population"
				histogramStyle="bins"/>
			<OutputProperties
				outputDatabase="twm_results"
				outputFrequencyTableName="MyFreq"
				outputHistogramTableName="MyHisto"
				outputStatisticsTableName="MyStats"
				outputValuesTableName="MyValues"/>
		</Analysis>
	</Project>
</Startup>

An example XML file that specifies multiple existing projects and modifies and executes the output properties of the first and just executes the second follows.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<Startup>
	<ErrorLog fileName="C:\Temp\BatchErrors.log"/>
	<Silent filename="C:\Temp\BatchMessages.log"/>
	<Connection name="twm batch demo"
		type="System"
		userId="twm"
		password="twm"/>
	<Project name="Help Tutorials - ADS and Reorganization" save="false">
		<Analysis name="Build ADS Tutorial" type="Build ADS" modify="true" 
			execute="true">
			<OutputProperties
				outputStyle="CreateTable"
				outputDatabase="twm_results"
				outputName="MyBuildADS"
				fallback="true"
				outputComment="My ADS comment"
				sql="sel * from twm.MyBuildADS order by 1;"
				collectStats="true"/>
		</Analysis>
		<Analysis name="Denorm Tutorial" type="Denorm" execute="true">
		</Analysis>
	</Project>
	<Project name="Help Tutorials - Descriptive Statistics" save="false">
		<Analysis name="Histogram Tutorial #1" type="Histogram" modify="true" 
			execute="true">
			<OutputProperties
				outputStyle="CreateTable"
				outputDatabase="twm_results"
				outputName="My Histogram Output"
				generateSqlOnly="false"/>
		</Analysis>
		<Analysis name="Frequency Tutorial #3" type="Frequency" execute="true">
		</Analysis>
	</Project>
</Startup>