Results Data | Factor Scoring | Vantage Analytics Library - Results Data - Vantage Analytics Library

Vantage Analytics Library User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Vantage Analytics Library
Release Number
2.2.0
Published
March 2023
Language
English (United States)
Last Update
2024-01-02
dita:mapPath
ibw1595473364329.ditamap
dita:ditavalPath
iup1603985291876.ditaval
dita:id
zyl1473786378775
Product Category
Teradata Vantage
This function outputs one or more columns of XML. You can transform the XML to HTML, which is easier to view—see Reports.

The following table is built in the requested Output Database by Factor Scoring. Note that the options selected affect the structure of the table. The table columns in bold comprise the Unique Primary Index (UPI). Also note that there may be repeated groups of columns, and that some columns will be generated only if specific options are selected.

Name Data Type Description
Key Key Column Type One or more unique-key columns that default to the index defined in the table to be scored.
Groupby Variable User-Defined A column is generated for each groupby column. Within each column there are distinct values of the groupby columns for which a factor model was built.
<app_var> User-Defined One or more columns as selected under Retain Columns. The data type defaults to the same as that within the appended table, but can be changed using Columns Types (for appended columns).
Factor x

(Default)

FLOAT Column generated for each scored factor. The names of the factor columns are Factor 1, Factor 2, ... Factor n.

Factor Analysis Score Reports

Table name = outputdatabase.outputtablename_rpt
Report Item Data Type Description
PartId INTEGER For each batch of XML in the second column that is 31000 bytes, partId is incremented.
XmlModel User-Defined A 31000 byte block of an XML representation of the reports if evaluate or scoreandevaluate are selected.

To extract the XML into a viewable format, run the following query:

SELECT XMLSERIALIZE(Content X.Dot) as XMLText
FROM (SELECT * FROM "outputdatabase"."outputtablename_rpt") AS C,
XMLTable (
'//*'
PASSING CREATEXML(C.XmlModel)
) AS X ("Dot");