7.00.02 - Benefits of Multiple-Input Functions - Aster Analytics

Teradata Aster® Analytics Foundation User GuideUpdate 2

Product
Aster Analytics
Release Number
7.00.02
Published
September 2017
Language
English (United States)
Last Update
2018-04-17
dita:mapPath
uce1497542673292.ditamap
dita:ditavalPath
AA-notempfilter_pdf_output.ditaval
dita:id
zuk1466006200888

Some benefits of multiple-input SQL-MapReduce functions over single-input functions that produce the same output are:

  • Prediction functions that use trained models have better performance and security.

    A multiple-input prediction function takes the model as a dimensional input, and one or more data inputs to which to apply the model.

  • Their inputs need not share a common schema.
  • They avoid the joins, unions, and creation of temporary tables their single-input counterparts need.
  • They facilitate creating new types of analytic functions (for example, multichannel attribution).
  • They use memory better, because:
    • Partitioning and grouping of tuples occurs before the function operates on them; therefore, less data is processed by the function.
    • One copy of a dimensional input is held in memory and used to operate on all tuples from other inputs.