Examples of Batch XML Files - 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

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>