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>