Preferences - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
apa1503087321277.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software

From the Tools menu, select the Preferences menu option to bring up the Preferences dialog.

Preferences

Timeouts

  • General
    • Database Connection Timeout(s) — Length of time the user interface or analyses waits to connect to Teradata. The default is 30 seconds.
    • Dictionary Query Timeout(s) — Length of time the user interface waits to interrogate the Teradata dictionary for database, table, view and column information. The default is 30 seconds.
    • Metadata Query Timeout(s) — Length of time the user interface waits to read and/or update the Teradata Warehouse Miner metadata when projects are opened or saved. The default is 30 seconds.
    • Data Retrieval Query Timeout(s) — Length of time the data panel or graphics waits to read a result set (table/view) in Teradata. The default is 30 seconds.
      The timeout feature is currently only available when connected to a Teradata database.

Controls

  • Selectors
    • List columns alphabetically — Column names are sorted alphabetically in column selectors. This option may be overridden when using a particular selector by right-clicking and using the pop-up menu to change the option.
    • Use bold characters for primary index columns — Primary index column names are displayed in bold font in column selectors. This option may be overridden when using a particular selector by right-clicking and using the pop-up menu to change the option.
    • Enable multi-column tree view selection — Tree view selectors displaying selected columns will include check boxes to allow selection of multiple columns for use with right-click menu options. These options include options for copying, pasting or selecting column names based on names copied to the Clipboard. This option may not be overridden for an individual selector. Also, if this preference is changed, it does not take effect on currently opened windows until they are closed and reopened.

Limits

  • Analysis
    • Maximum Result Rows to Display — Numbers of rows to display in the data panel and graphics for analyses that generate a SELECT, CREATE TABLE or VIEW. The default is 1,000 rows.

      A maximum amount of 100,000 rows may be specified. A value of -1 displays all rows.

      A value of 0 is invalid and results in an error.

  • Wizards
    • Maximum Distinct Values to Display — Number of distinct values that are fetched by the wizard for analyses that have a wizard to determine distinct values (Recode, Design Code, Denormalization, Logistic Regression, Decision Tree and Variable Creation). The default is 1000 distinct values.
    • Use sampling to retrieve distinct values data — Number of rows that are initially requested for sampling that can be used for analyses which have a wizard for determining distinct values. The default is 10,000 rows.
    • Number of Rows to Sample — If Use sampling to retrieve distinct values data is enabled, the number of rows to sample needs to be specified here.

Execution

  • Projects
    • Continue project execution upon analysis error — If an analysis fails while executing a project, execution continues with the next analysis.

Archive

  • Automatic Archive Options
    • Automatically archive deleted projects, analyses, etc. — Whenever a project, analysis or attachment is deleted, it is automatically archived to the standard location in the application file storage area.
      The entire project is automatically saved prior to the deletion of the requested item.

Defaults

  • Default Output Comment — When a value is entered here, any new analysis of a type that supports the post processing output panel will contain this value as the initial value of the Comment on Output Table field. Note that the text string entered here can contain substitution parameters representing an output category, the project name or the analysis name as follows. The resulting comment must not exceed 255 characters.
    • <Category> - Score / ADS / Stats / Other
    • <Project> - The name of the project that contains the analysis
    • <Analysis> - The name of the analysis that is creating the output

      For example, the string TWM : <Category> : <Project> results in a default output comment of TWM : Score : MyProject for the output of a scoring analysis in the project MyProject.

      TWM : <Category> : <Project> is the default value of this option.

  • Default Procedure Comment — When a value is entered here, any new analysis of a type that supports the option to create a stored procedure will contain this value as the initial value of the Procedure Comment field. Note that the text string entered here can contain the same substitution parameters that are supported in the Default Output Comment field described above. The resulting comment must not exceed 255 characters.

    TWM : <Category> : <Project> is the default value of this option.

  • Default SQL Font — A font type and size may be entered here or selected via a standard dialog by using the Browse button. The specified font will be used as the default font when entering SQL for any new Free Form SQL analyses (although the font in this case may be changed via a right-click option). The specified font will also be used in all new and existing analyses that allow entering free-form SQL text, such as in expert where clause panels and in SQL Text and Formula elements in Variable Creation analyses. The default SQL font is further used in the display of results SQL in all analyses that provide such display and in the display of SQL text for Variable expressions in Variable Creation (through the use of the SQL dialog button).

    If a font size is entered as text rather than selecting it in the Browse dialog, the value entered must be a decimal value between 6 and 36, entered in the current locale format. Note also that if a font style such as Bold or Italic is selected in the Browse dialog, it is ignored.

Startup

  • Data Source to connect to — When a data source is entered here, for successive executions of TWM, the user will be automatically connected to this data source.
  • First project to load — If the user wishes to automatically load a project associated with the data source specified above, the name of the first project to load is entered here. A drop-down list of all projects for the data source is provided for project selection.
  • Second project to load — The user can load up to three projects upon startup. The optional second project to load is entered here.
  • Third project to load — The optional third project to load is entered here.
  • Open new project — Check this option to open a new project automatically upon startup. If checked, the new project is opened after any requested projects are loaded.