Matrix Building Function | Vantage Analytics Library - Matrix Building - 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

The matrix function takes a database table and builds a matrix of the default or specified type. By default, the function builds an extended sum-of-squares-and-cross-products (ESSCP) matrix. For other matrix types, see matrixtype in Syntax.

The function generates and runs SQL that calls the Teradata Vantage CALCMATRIX table operator and returns a result set or database table.

Matrix Building reduces numeric columns in potentially huge relational tables to a comparatively compact matrix—n column become an nxn. You can input the matrix to a linear regression or factor analysis algorithm.

The matrix function must operate on numeric data. DATE columns do not produce meaningful results.