NeuralNet (version 1.0) - 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
SELECT * FROM NeuralNet (
  ON (SELECT 1) PARTITION BY 1
  [ Domain ('host:port') ]
  [ Database ('db_name') ]
  [ UserID ('user_id') ]
  [ Password ('password') ]
  [ SSLSettings ('SSLsettings') ]
  [ SSLTrustStorePassword ('SSLtruststorepassword') ]
  InputTable ('table_name')
  OutputTable ('table_name')
  [ WeightTable ('table_name') ]
  InputColumns ('InputTable_column1', 'InputTable_column2', ...)
  ResponseColumns ('string_value1', 'string_value2', ...)
  [ GroupByColumns ('InputTable_column1', 'InputTable_column2', ...) ]
  [ HiddenLayers ('integer_value1', 'integer_value2',...) ]
  [ Threshold ('double') ]
  [ MaxIterNum ('integer') ]
  [ LearningRate ('double') ]
  [ ActivationFunction ({ 'logistic' | 'tanh' }) ]
  [ ErrorFunction ({ 'sse' | 'ce' }) ]
  [ Algorithms ('backprop') ]
  [ LinearOutput
    ({ 'true'|'yes'|'t'|'y'|'1'|'false'|'no'|'f'|'n'|'0' }) ]
  [ OverwriteOutput
    ({ 'true'|'yes'|'t'|'y'|'1'|'false'|'no'|'f'|'n'|'0' }) ]
);