Adding a New Analysis - Teradata Warehouse Miner

Teradata® Warehouse Miner™ User Guide - Volume 1Introduction and Profiling

Product
Teradata Warehouse Miner
Release Number
5.4.6
Published
November 2018
Language
English (United States)
Last Update
2018-12-07
dita:mapPath
rfc1538171534881.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2300
Product Category
Software
  1. From File, select Add New Analysis.
    Add New Analysis

  2. Highlight the analysis and select OK. The window for the selected analysis appears.
  3. Select the Variable Creation analysis icon. One or more additional fields display, as shown in the following example.
    Add New Analysis: Variable Creation

    • Analysis name — This is the name to assign to the new analysis. The default shown is based on the type of analysis and a counter to make it unique within the project.
    • Analysis template — This is an optional template indicator (default is none). When a template type is selected here and OK is selected, two or more analyses are created as called for by the template, with connecting fields and required options pre-set. Immediately after the analyses are created, a message displays further instructions for you tofollow to complete the template. The templates provided include:
      • Query with Derived Table — A derived query analysis and base query analysis are created.
      • Query with Subquery — A subquery analysis and base query analysis are created.
      • With Query — A With query analysis and base analysis are created.
      • With Recursive Query — A With Seed query, With Recursive query and base query analysis are created.
      • With Recursive View — A With Seed query, With Recursive query and base view analysis are created.
      • Union of Queries — Two analyses to combine with a set operator are created.
    • Operator — This displaysonly when the requested template type requires it. The possible values are outlined below.
      Query with Subquery
      • Between
      • Exists
      • In
      • Is Null
      • Is Not Null
      • Like
      • Not Between
      • Not Exists
      • Not In
      • Not Like

      The SQL predicate operators above are the operators most frequently used with subqueries. For more Variable Creation – INPUT – Variables – SQL Elements and SQL operators information, see Teradata Warehouse Miner User Guide: Volume 2, ADS Generation (B035-2301).

      Union of Queries
      • UNION
      • UNION ALL
      • INTERSECT
      • INTERSECT ALL
      • EXCEPT
      • EXCEPT ALL

      The keyword ALL in the list above means to retain duplicate rows in the result set. The UNION keyword indicates that rows output from both the first and second analysis are included in the answer set. INTERSECT is used to indicate that only rows included in both input data sets are included in the output data set. And finally, EXCEPT is used to indicate that all rows from the first data set are included in the output data set except those occurring in the second data set.