Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Teradata Warehouse Miner
User Guide

The Project element takes a name attribute, and the following optional attributes: new, execute, save, runToEnd, analysisName and continueOnError. This element tells TWM to load the specified project by name from the current connection.

If the new attribute is used, a new project with the specified name will be created. Note that a new project may contain only new analyses of type Frequency, Histogram, Statistics, Values and/or Data Explorer. Analyses of type Refresh Analysis that are specified as new need to be referenced from an existing, not a new project, because they must reference an existing analysis in the same project. Also, only one new project is allowed to be created in batch mode execution. If the new attribute is set, then it is assumed that all analyses specified for the project are new analyses.

If the save attribute is set and the project is running in silent mode, then the project will be saved in the TWM metadata. If save is set to false, the analysis will not be saved and will not be available to be accessed for future runs. The default for the save attribute is true.

The continueOnError attribute will continue execution of the project’s analyses if the execute attribute has been specified and one or more of the project's analyses fails to complete properly. If this attribute is not specified, then the Continue project execution on analysis error preferences option setting is used.

The runToEnd attribute allows the project to start execution at a specific analysis and continue to the last analysis that is defined for that project. If the runToEnd attribute is set, then the analysisName attribute must also be provided to specify which analysis name the execution is to begin at.

To execute an existing project, execute and save it, use:

<Project name="MyProject" execute="true" save="true"/>

The user can specify an individual analysis to be executed by setting the analysisName attribute (causing the first analysis in the project with the requested name to be selected). If more than one analysis is to be run in a project, then the user would need to specify the project and analysis pair for each analysis to be run. For example:

<Project name="MyProject" analysisName="MyAnalysis1" execute="true"/>

<Project name="MyProject" analysisName="MyAnalysis2" execute="true"/>

When an analysis name is specified with the runToEnd attribute, all analyses following the requested analysis in the project are executed after the requested analysis. In this case, however, analysis specifications for new and modify cannot also be used.

<Project name="MyProject" runToEnd="true" execute="true" analysisName="MyAnalysis"/>

If an analysisName is not specified, then all the analyses in the project will be executed.

There is an alternative method, described below, that enables the user to specify and execute multiple analyses within one or more projects with the ability to modify output properties or run the analysis without modification. Examples of this type of batch execution are provided in Examples of Batch XML Files.