This function builds a sum-of-squares-and-cross-products (SSCP) matrix or other derived matrix type from a table in a Teradata Database. It does this by generating and executing the SQL to call the Teradata CALCMATRIX table operator provided in Teradata beginning with the 14.10 release. The results are stored either in a table or as a result set returned to the user. The purpose in building a matrix depends on the type of matrix built. For example, when a correlation matrix is built, it can be viewed to determine the correlations or relationships between the various columns in the matrix.
Refer to the Teradata reference manual SQL Functions, Operators, Expressions, and Predicates, B035-1145, for more detailed information about the CALCMATRIX table operator.