Sparse Tables and Dense Tables - Aster Analytics

Teradata Aster Analytics Foundation User Guide

Product
Aster Analytics
Release Number
6.21
Published
November 2016
Language
English (United States)
Last Update
2018-04-14
dita:mapPath
kiu1466024880662.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
B700-1021
lifecycle
previous
Product Category
Software

Sparse tables are sometimes used by some functions (for example, SVM) to allow processing of more attributes than the database can support as columns. In other cases, dense tables are used. Often, algorithms perform more efficiently if the input is a dense table.

Pivot and Unpivot functions convert from one to the other.