- Row-major matrix: Each row is processed as a wavelet that is grouped by its MATRIX_ID and ROW_AXIS, and ordered by its COLUMN_AXIS.
- Column-major matrix: Each column is processes as a wavelet that is grouped by its MATRIX_ID and COLUMN_AXIS, and ordered by its ROW_AXIS.
A MATRIX_SPEC is used to reference any Teradata accessible table or a view, a derived-table, or a particular layer residing within an ART. When used to reference a layer of an ART, the LAYER parameter must be included, except the case in which the layer is ARTPRIMARY, in that case the LAYER parameter can be omitted.
The identifier and PAYLOAD fields can be renamed using AS clauses. However, this may not affect the output field names for the PAYLOAD fields because the PAYLOAD fields are input fields. The output payload field name is only affected if the function uses the input payload field name as the output field name or as part of the output field name.
The identifier columns cannot reference a user-defined type, complex data type or LOB column. Dot notation is allowed.